Tag: 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

Prevent YTD, QTD, MTD Results Extending Forward In Power BI

Recently I had a unique question pop up at the Enterprise DNA Support Forum. In this scenario, we are looking to evaluate YTD sales but we don’t want to evaluate anything past the last sale that may have occurred. We only want to show the cumulative YTD total up to the last sale. This is

Continue reading