Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors