Category: Time Intelligence

Running Totals Example In Power BI Using DAX Formula

Sometimes calculating running totals is a far better away to analyse trends than just looking at actual results on a daily basis. So that’s why I’m going to show you in this example how you can implement a running total calculation which is dynamic, which flows and integrates well into the rest of your model.

Continue reading

Segment Your Customers Into Groups – Advanced DAX Example

I’m getting complex today with DAX, but that’s because I enjoy showcasing the power of this formula language inside of Power BI. I want you to get there too. It’s why I always want to get practical around implementation. This is a perfect example of a really valuable commercial insight you can extract out of

Continue reading

Compare Performance vs Forecasts Cumulatively w/DAX

Showcasing results cumulatively is, in my opinion, the best way to showcase trends in your data. When comparing data versus budget or forecasts, showing the trends or divergence in trend is essential. You want to make sure you can identify when your performance is breaking down as soon as possible and by viewing this cumulatively

Continue reading

Compare Actual Results to Budgets or Forecasts in Power BI

Budgeting in Power BI … unfortunately, it’s just not that easy to implement. I wish it was as easy as bringing in your actuals and your budgets and then like magic you would be able to see the performance insights you need visualized in a compelling way. That’s why I wanted to create this tutorial

Continue reading