Cumulative Running Total

Question

I am trying to calculate a cumulative total of [payments], but I want it to sum in ascending order of [day]. All solutions I have found start the running total with the largest payments down to the smallest. I want the cumulative total from day 0 - x. Thanks in advance.&nbsp;Desired Result:Day &nbsp; &nbsp; &nbsp; &nbsp; Payment &nbsp; &nbsp; &nbsp; &nbsp; Cumulative Total0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 51 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 152 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 223 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 42&nbsp;

greg_deckler · Accepted Answer

Cumulative Total Column =&nbsp;
&nbsp; VAR __Day = 'Table'[Day]
RETURN
&nbsp; SUMX(FILTER('Table',[Day] &lt;= __Day),[Payment])
&nbsp;
Cumulative Total Measure =&nbsp;
&nbsp; VAR __Day = MAX('Table'[Day])
RETURN
&nbsp; SUMX(FILTER(ALL('Table'),[Day] &lt;= __Day),[Payment])

Forum Discussion

Cumulative Running Total

2 Replies

Related content

Cumulative Total

SumX? - cumulative running total

Running Totals

Cumulative (Running) Totals in DAX

Cumulative Total