Tag: Cumulative totals DAX

DAX Cumulative Total Pattern In Power BI

total-pattern-in-power-bi

I’m going to show you some great resources and tips around DAX cumulative total pattern. These are helpful in a number of scenarios you’ll be facing as you continue to work on reports and dashboard within Power BI. You can find comprehensive information on this in the Enterprise DNA Forum. There’s a lot of great

Continue reading

Combining DAX Patterns Or DAX Formulas In Power BI

For this tutorial, I’ll be showing you how to combine multiple DAX patterns in Power BI. This strategy is one of the many applications of measure branching and is an effective way of producing high-quality reports. When your goal is to analyze trends over time, sticking to basic formulas may not always give you valuable

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

Calculating Reverse Cumulative or Reverse Running Total In Power BI

Calculating a cumulative total, also known as a running total, in Power BI, is definitely common to most businesses due to its indispensability in performing calculations to show the total of a measure up to a certain date. But did you know that creating a reverse cumulative total is as essential as calculating the cumulative

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