Tag: Time Intelligence Calculations

Power BI Financial Year To Date Calculations

Power BI Financial Year To Date Calculations

In this tutorial, I’m going to talk about Power BI financial year to date calculations. Achieving a year to date analysis of a selected period is quite complex, but I’ll demonstrate to you a formula technique that enables you to quickly create a cumulative total over your specific financial year. You can watch the full

Continue reading

Power BI DATEADD Function & Time Related Insights

Power-BI-DATEADD-Function-&-Time-Related-Insights

In this tutorial, I’m going to cover the best time intelligence function, the Power BI DATEADD. It’s one of the time intelligence functions that you should introduce yourself to as soon as possible when learning Power BI. You may watch the full video of this tutorial at the bottom of this blog. The Power BI

Continue reading

Power BI Holiday Calendar – Calculate Date W/DAX

Creating a Power BI holiday calendar is crucial for many time intelligence calculations. In this tutorial, I’m going to show you how to calculate specific holiday dates using DAX measures. You can watch the full video of this tutorial at the bottom of this blog. This example came from one of the Enterprise DNA initiatives

Continue reading

TOPN DAX To Showcase Top Customers This Period vs Last Period

TOPN DAX To Showcase Top Customers This Period vs Last Period

In today’s post, I want to show you a unique way of using the TOPN DAX ranking function to showcase your top clients over multiple periods. You can also watch the accompanying Power BI tutorial video below this post for more help. You may watch the full video of this tutorial at the bottom of

Continue reading

Adding Time Intelligence To Customer Dashboards In Power BI

Adding-Time-Intelligence-To-Customer-Dashboards-In-Power-BI

In this tutorial, you’ll learn how to make a customer dashboard more intuitive using time intelligence in Power BI. This is the second step when creating a customer deep dive dashboard. When creating visualizations, you’ll most likely have to compare different time periods. This could be a comparison between the cumulative sales for two simultaneous years. So, you need to start writing more complex

Continue reading