Getting Running Total in matrix, based on Measure

Question

Hello,&nbsp;Having some troubles calculating Running Total of a measure, in a matrix (so the running total would be based on a measure, not column). Expected result is running total being summed in the following cadence:&nbsp;&nbsp;AmountTotalJan1010Feb3040Mar60100Q1100100Apr30130May25155Jun20175Q275175&nbsp;The existing measure is below:&nbsp;_Renewal amount = SUMX(SUMMARIZE(_Timeline,_Timeline[_M],"Renewal ARR",[_Renewal amount raw]),[Renewal ARR])&nbsp;Any ideas on how this could be achieved?&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;niculeica&nbsp;,
Please have a try.
_Renewal amount running total =
CALCULATE (
    [_Renewal amount],
    FILTER (
        ALLSELECTED ( _Timeline[_M] ),
        ISONORAFTER ( _Timeline[_M], MAX ( _Timeline[_M] ), DESC )
    )
)

&nbsp;
How to Get Your Question Answered Quickly&nbsp;
&nbsp;
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
&nbsp;
Best RegardsCommunity Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;

Forum Discussion

Getting Running Total in matrix, based on Measure

1 Reply

Related content

Running Maximum

Running sum

Pipeline not running

Running Totals

using Virtual tables to get running total

	Amount	Total
Jan	10	10
Feb	30	40
Mar	60	100
Q1	100	100
Apr	30	130
May	25	155
Jun	20	175
Q2	75	175