Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculating Remaining budget

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

 

Need Help
  • parry2k's avatar
    parry2k
    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] ) 
)

     

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    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] ) 
)