Tag: Cumulative Total Pattern

Advanced Analytics in Power BI: Layering Multiple 'What If' Analysis

In this tutorial, I show you how you can layer multiple “What If” analysis or scenarios in Power BI, one on top of each other. It takes your analytical output through the roof if you use this technique effectively. As you likely know, I am a huge promoter of scenario analysis in Power BI. Scenario

Continue reading

Showing Actual Results vs Targets Only To Last Sales Date In Power BI

Actual Vs Target To Last Sales Date Using DAX Cumulative Totals In Power BI

In this example, I want to show you how we can generate cumulative totals but only up to a certain point. A really relevant example if you are running some time comparison analysis and you’re looking at trends over time as a cumulative total in Power BI. Here’s a description of a specific scenario below.

Continue reading

How To Calculate A Cumulative Run Rate In Power BI Using DAX

With this tutorial, I want to showcase how you can calculate a cumulative run rate into the future based on some historical results. This was a requirement from the Enterprise DNA Support Forum where a member needed a forecast projection out into the future. Enabling them to compare current results to an average run rate over

Continue reading

Create Dynamic Cumulative Totals Using DAX In Power BI

Create Dynamic Cumulative Totals Using DAX In Power BI

In this tutorial, we’re going to do a deep dive into the cumulative total formula combination that can be used in Power BI. Cumulative totals are a great way of showing trends over time and then also showcasing differences in trends between different timeframes. There is a common combination of DAX functions to use that

Continue reading