Calculating Remaining budget

[Anonymous]

Hello,

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

[parry2k · Accepted 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] ) 
)

[v-shex-msft · Accepted solution]

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

[parry2k · Accepted 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] ) 
)