Tag: Time Intelligence

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

Compare One Sale Versus The Last Sale (No Time Intelligence)

In this unique example, I will show you how you can compare a sale, on any particular day to the very last sale that was made. This will be relevant if you don’t actually sell something every single day or if you are looking at a particular customer or a product and you want to

Continue reading

Month to Date (MTD) To Today’s Actual Date In Power BI Using DAX

Showcasing month to date calculations to the current date (ie. today) is a common problem that I see all the time. I’ve been asked this on the Enterprise DNA Support Forum quite a lot so it’s timely to create a tutorial around how to solve it. In this tutorial I’m going to show you how you

Continue reading

Time Intelligence For Non Standard Date Tables In Power BI

Running time comparison type analysis on custom calendars is a little bit more complex than if you were using a standard calendar. The reason behind this is because the time intelligence functions available for custom calendars allow users to quite easily and effectively write a formula and achieve the results that they want. Unfortunately  with non-standard

Continue reading

Previous Weeks Sales – Advanced Time Intelligence w/DAX in Power BI

Calculating the difference between weekly sales results in Power BI is unfortunately not that easy. The reason behind this is that Power BI doesn’t have a weekly based, built-in time intelligence function. The only available options are for the day, month, quarter, and year. Therefore, to be able to work out weekly results in Power

Continue reading