Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper V
Helper V

measure which calculates values based on value of previous month



Im trying to create a measure that calculates the cumulative value. This is calculated with the formula:

cumulative = cumulative value previous month + total costs


Only May contains a cumulative value, which is 1,058,333.40. With this value (from a column) I have to calculate the cumulative value of the other months.




Im trying a few things but I cant seem to get the correct values, only for June, because for July he takes the empty value of Cumu column for June + total costs.


the measure i use:

Cumulative = Calculate(MIN('table1'[Cumu])  + [total costs]  , DATEADD('Query1'[Date], -1, MONTH))


Anyone an idea how to get this working?

Solution Sage
Solution Sage

Hi @TechR21 


@Greg_Deckler explains in the video to get a running total 


You can also try



Costs Running Total = 
    VAR maxdate = MAX(Cost_Table[Date])
        SUM(Cost_Table[Cost Amount]),
        Cost_Table[Date] <= maxdate,






If this post helps, then please Accept it as the solution 




but your measure doesnt include the table1[cumu] value so it wont give the correct values.


the May value (1,058,333.40) is the starting point. Together with the costs of that month , that is the cumulative value


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.