Tag: Time Intelligence Calculations

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

Using Calculate Function Inside Power BI

Using Calculate Function Inside Power BI

For this tutorial, I’ll cover how the CALCULATE function works and why it’s so crucial in Power BI. I’ll also show you some examples of its application. You can easily branch out to time intelligence calculations by using the CALCULATE function. Once you apply this technique, you’ll be able to produce high quality insights inside

Continue reading

Calculate Workdays Between Two Dates In Power BI

Calculating Workdays Between Two Dates in Power BI

I’m going to show you how to calculate workdays between two dates either with the holidays counted or without the holidays. This is a topic that’s been asked over and over again on the Enterprise DNA Forum. I also believe that this will be a great way to close this Time Intelligence series, knowing that

Continue reading

Using The Offset Function In Extended Date Tables

Offset Function in Extended Date Tables

I’m going to show you how to use the offset function in Power BI. It’s one of the most dynamic tools you can use especially in your date tables. Once you master how to apply it in your time intelligence projects, you can get more in-depth insights that you won’t get using any other approach.

Continue reading

Using IsAfterToday for Power BI Time Intelligence Scenarios

Using The Extended Date Table - ISAFTERTODAY

I’m going to show you how to use IsAfterToday in extended date tables for Power BI time intelligence scenarios. When it comes to DAX functions and other tools, I assign them certain jobs or personas in my head so that I can easily remember what they do. For example, I see SWITCH as an air

Continue reading