Category: Time Intelligence

The DATEADD Function. The Best And Most Versatile Time Intelligence Function in Power BI

The DATEADD function is by far my go to time intelligence function in DAX at the moment. Mainly because of it’s immense versatility to generate time comparisons over a range of different time frames. This detailed video will go through all the various aspects of how to set up time comparison analysis with this function.

Continue reading

Compare Cumulative Results For Multiple Months

Showcasing your results cumulatively is such a powerful way to visualize your data over time, especially if you are trying to show the difference in performance from one time period to another. When you try to present this at a daily or even monthly level, identifying the trend isn’t always so obvious. When you place

Continue reading

Discover How To Repeatedly Project A Current Trend Forward In Power BI

In this unique example, I want to show you how you can take a historical trend and repeatedly project it forward. This particular example came to me from a question in the Enterprise DNA support forum. An Enterprise DNA member needed to carry out this analysis in the real world. They had to take historical

Continue reading

Calculate Consecutive Weekday & Weekend Days In Power BI Using DAX

We’re going to work through something really unique around Time Intelligence inside of Power BI. This scenario was brought up on the Enterprise DNA Support Forum, where there was a need to compare “like-for-like” within months. In other words, they wanted to compare the first working day in a particular month to the first working

Continue reading

Implementing DAX Measure Groups Into Your Power BI Reports – Modeling Review

I want to touch on a really important topic within this tutorial. In many of the showcase demos that Enterprise DNA releases across webinars, summits, and to Enterprise DNA members you will see that the use of measure groups is extensive. There is a very good reason why measure groups have been implemented in all

Continue reading