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.
Category: Time Intelligence
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
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
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