Tag: Cumulative Total Pattern

The Difference Between ALL And ALLSELECTED DAX Functions In Power BI

The Difference Between ALL And ALLSELECTED DAX Functions In Power BI

The difference between ALL and ALLSELECTED DAX functions can be relatively confusing when you’re starting out with Power BI. In this tutorial, I’ll quickly go over the main differences between those two commonly used DAX functions and their respective usages in your Power BI reports. Let’s take a look at this example. I’ll use this

Continue reading

Calculating A Cumulative Run Rate Using DAX In Power BI

When analyzing actual results in your data, you may sometimes want to compare it to a forecast or run rate. In this tutorial, I’ll show you how to calculate a cumulative run rate based on some historical results. This came out as a request in the Enterprise DNA Support Forum where a member needed a forecast

Continue reading

Showcasing Budgets In Power BI – DAX Cumulative Totals

Recently, I built and showed a Budgeting Analysis Dashboard in one of Enterprise DNA’s workshop. One feature of that Dashboard is the Cumulative Budget view. The webinar is linked here. The dashboard itself is dynamic so I can change the time frame and select the products I want to track. This makes exploring the data

Continue reading

Showing Cumulative Results vs Targets Only To Last Sales Date in Power BI

In this tutorial I demonstrate how to create a cumulative visualization in Power BI, showing cumulative results versus targets or budgets. This is a really good visualization to show things over time. But, in this example, I only want to show the results up to today’s date or the very last date of a sale

Continue reading

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