Forum Discussion
Calculating Remaining budget
- 6 years ago
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] ) ) - Anonymous6 years ago
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
Regards,
Xiaoxin Sheng
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
Regards,
Xiaoxin Sheng