# Calculate A Reverse Cumulative Total In Power BI Using DAX

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.

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.

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

See below….

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.

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

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…..

***Learn To Master Power BI Through Our Many Virtual Training Workshops***

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