cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## 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 :

2 ACCEPTED SOLUTIONS
Super User

@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] )
)``````

Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
2 REPLIES 2
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User

@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] )
)``````

Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Announcements