Calculate A Reverse Cumulative Total In Power BI Using DAX

No comments

In this example, I will show you how you can create a reverse cumulative total inside of Power BI using DAX.

This question came up recently on the Enterprise DNA Support Forum.

Reverse Cumulative Sum Support Forum

You can view this forum post here Reverse Cumulative Sum

A member had a unique requirement where they needed a cumulative total from December all the way to January.

They also wanted to make it dynamic. So whenever they wanted to change the year filter on the page the reverse cumulative total would adjust for just that particular context in the report.

After working through a solution, ultimately the answer was quite simple.

It was a simple variation on the very common cumulative total formula combination that you can utilise and re-use quite effectively inside of Power BI.

Cumulative Total Pattern Power BI

All it required is a small adjustment to the row context filtering which occurs within the FILTER function of the formula pattern.

See below….

Reverse Cumulative Total Power BI DAX Pattern

This is a really good revision of how the CALCULATE function operates when used in combination with the FILTER function. When you use these two DAX formulas together you can generate quite interesting and unique insights into your data.

Reverse Cumulative Total

Some recommended links for you so you can dive into cumulative total techniques inside of Power BI.

Create Dynamic Cumulative Totals Using DAX In Power BI

Cumulative Totals In Power BI Without Any Dates – Advanced DAX

Enjoy working through this one. It is quite a unique example but one that I’ve seen requested a few times now.

Hopefully, you can get a good understanding of how this particular calculation operates inside Power BI.

Sam

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online
Enterprise DNA Events

membership banner 3

***** Related Links*****
Simple Filters w/CALCULATE – (1.13) Ultimate Beginners Guide to DAX
How To Calculate Budget Or Forecast Results Cumulatively In Power BI
Compare Multiple Metrics Cumulatively in Power BI using DAX

***** Related Course Modules*****
Mastering DAX Calculations
Solving Analytical Scenarios w/Power & DAX
Unique Analytical Scenarios

***** Related Support Forum Posts*****
Cumulative Total VS Cumulative Total LY – Cleaning Visual
Cumulative Total Question
Cumulative Total This Year vs Last
For more cumulative total support queries to review see here…..

Enterprise DNA Events

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.