Forum Discussion
Solved
Cumulative Totals Row
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 |
You may select Unpivot Columns in Query Editor, then research the code generated by Quick measure Running total.
3 Replies
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]))
You may select Unpivot Columns in Query Editor, then research the code generated by Quick measure Running total.
