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

Compare Multiple Metrics Cumulatively in Power BI using DAX

I’ve previously showcased how you can compare your actual results versus your budgeted results. But, what if you also wanted to overlay some time comparison information so you’re comparing your actuals versus budget versus last year? Or perhaps versus last quarter? Or against any other time period you may want to select? In this video

Continue reading

Scenario Analysis Techniques Using Multiple ‘What If’ Parameters – Advanced DAX

Power BI is an incredible tool to run scenario analysis and what-if analysis examples. I’ve actually never seen or come across an analytical tool that is as effective and intuitive to implement this type of complex analytics. The key is that you’ve got to think more analytically about the underlying elements in your datasets than

Continue reading

Change Your Visuals Size By Ranking Logic in Power BI using DAX

Have you ever wanted to create a visualization which changes based on any ranking selection you could make? In this video, I show you exactly how to do it. Think of a scenario where you want to showcase your top 20 clients. Pretend you’re in a meeting saying, “These are the clients that are contributing

Continue reading