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.
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.
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.
***** 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
***** Related Links*****
***** Related Course Modules*****
***** Related Support Forum Posts*****