In my table, there are the measure : Budget; Depense
I would like to calculate the monhly cumul of remaining budget.
I would be something like below :
could you please help?
Thanks in advance
Go to Solution.
@Anonymous there are so many posts on how to get cummulative total, first basic thing is that you need to have date dimension in your model to perform this kind of calculation.
here is an idea on how you can do this,
Cummulative Budget =
CALCULATE ( SUM ( Table[Actual] ),
FILTER ( ALL ( Calendar ), Calendar[Date] <= MAX ( Calendar[Date] )
Proud to be a Super User! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
View solution in original post
HI @Anonymous ,
You can take a look at the below blog that told about rolling total calculation in Dax:
DAX 101: Computing running totals in DAX
Please share some dummy data with minimum data structure for test if above not meet for your requirement.
How to Get Your Question Answered Quickly
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!