How to get a running total of Monthly numbers produced in a Matrix

[rjausma]

Hi All,

I've run into an issue trying to get a running total of Savings/Projected Savings based on the renewal dates of a contract. 

If figured out how to display the monthly savings (over 4 years) in a Maxtrix using:

"Forecasted Monthly Savings = CALCULATE(

    DIVIDE('Maintenance Contracts'[Determine Savings Actual/Projected],12,0),

    DATESINPERIOD('Date Lookup'[Date],Max('Date Lookup'[Date]),-4,YEAR)

    )"

What I need is to get a running total of the Monthly values displayed in the Matrix. 

Thanks in advanced

[rjausma · Accepted solution]

Found the answer after several searches on StackOverFlow.com

CALCULATE(

    SUMX(VALUES('Date Lookup'[Month]),[Forecasted Monthly Savings]),

    FILTER(ALL('Date Lookup'),

    'Date Lookup'[Date] <= MAX('Date Lookup'[Date])

    &&

    'Date Lookup'[Year] = MAX('Date Lookup'[Year])

    )

)

This added up the monthly values

[v-chuncz-msft]

@rjausma 

You may research the code generated by Quick measure Running total.