Cumulative Totals Row

[KH11NDR]

Hi Guys,

How do i do the Cumulative Total

Thanks

	01/01/2018	01/02/2018	01/03/2018	01/04/2018	01/05/2018	01/06/2018	01/07/2018	01/08/2018	01/09/2018	01/10/2018	01/11/2018	01/12/2018
Values	0	10	20	30	40	50	60	70	80	90	100	110
Cumulative	0	10	30	60	100	150	210	280	360	450	550	660

[v-chuncz-msft · Accepted solution]

@KH11NDR,

You may select Unpivot Columns in Query Editor, then research the code generated by Quick measure Running total.

[Maddy99]

The first stap is to pivot your table. 

column name - Date - value

Cumm total - 1/1/2018 - 10

cumm total - 2/1/2018 - 5 ect

then you can to a measure on value:Total = Sum('table'[Value])

then an other measure for the cumalative. if you want it **bleep** in the year you can use. TOTALYTD function:

 total **bleep** = Calculate([Total], TOTALYTD('table'[Date]))

[KH11NDR]

@Maddy99

 total **bleep** = Calculate([Total], TOTALYTD('table'[Date]))

The date field, is looking for a measure , my date field is a column.