Running Total 4th Line

[jamescosten]

I have a table shown Below:

I need to have a 4th line that takes a cumulative total over the months. So February shows the total for Jan and Feb, March Shows Jane Feb & March etc. I have tried the Running Total Function but it doesnt seem to do what i want.

This is the Filters i Have also:

It is taking a sharepoint list and filtering to 2022 only. The Choice field on the list is for Closed and Open NCR's. i then have a difference line between the two to show backlog.

[v-kkf-msft · Accepted solution]

Hi @jamescosten ,

Please try the measure.

Measure = 
CALCULATE (
    SUM ( 'Table'[Backlog] ) + SUM ( 'Table'[Closed] )
        + SUM ( 'Table'[Open] ),
    DATESINPERIOD ( 'Calendar'[Date], MAX ( 'Calendar'[Date] ), -2, MONTH )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@jamescosten , usally we have this kind of measure for running total

Cumm = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

Cumm = CALCULATE(SUMX(Values('Date'[Month]), [Measure]) ,filter(allselected('Date'),'Date'[date] <=max('Date'[date])))