Forum Discussion

kcdistiller's avatar
kcdistiller
Frequent Visitor
9 years ago

Calculate Running Total Using Input from Another Calculation (Measure)

There are many solutions to calculate a running total based on dates or counts within a table, but I have not found a way to create a running total measure using input from another measure. Consider ...
Need Help
GilbertQ's avatar
GilbertQ
Super User
9 years ago

hi kcdistiller

 

In terms of your data, does it have any dates associated with it?

 

If you have got a date, then you can easily create an interim calculated measure which will be the previous dates value.

NOTE: You will need a date table and create a relationship between the tables for this to work.

 

The example below is getting the values for the Previous Day.

 

Previous Row Data = 
CALCULATE (
    [Actuals],
        PARALLELPERIOD ( 'Date'[Calendar Date], -1, DAY ),
    )

And then your running total could be [Column D] + [Previous Row Data]

kcdistiller's avatar
kcdistiller
Frequent Visitor
9 years ago

Most solutions that I've found use dates, but there are no dates associated with my data.