Forum Discussion
KH11NDR
Helper IV
Helper IVHow do i create a calculated column or measure for totalling up another column as cumulative?
Hi Guys, This is what I want to do, create another column or measure that calculates Total sales per month per project. My data is exactly how it is in the table without the "Total Sales" column...
KH11NDR，
Please check attached PBIX file.
Regards,
Lydia
KH11NDRHelper IV
Helper IVDo you think it has anything to do with me Unpivoting my columns?
Original Data
| Project ID | 01/07/2017 | 01/08/2017 | 01/09/2017 | 01/10/2017 | 01/11/2017 | 01/12/2017 | 01/01/2018 | 01/02/2018 |
| AAAA | 0 | 5 | 10 | 15 | 20 | 25 | 30 | 35 |
| BBBB | 0 | 7 | 12 | 18 | 24 | 30 | 36 | 42 |
Power BI Table
| ProjectID | Dates | Value |
| AAAA | 01/07/2017 | 0 |
| AAAA | 01/08/2017 | 5 |
| AAAA | 01/09/2017 | 10 |
| AAAA | 01/10/2017 | 15 |
| AAAA | 01/11/2017 | 20 |
| BBBB | 01/07/2017 | 0 |
| BBBB | 01/08/2017 | 7 |
| BBBB | 01/09/2017 | 12 |
| BBBB | 01/10/2017 | 18 |
| BBBB | 01/11/2017 | 24 |
And then in Power BI Matrix table, another row showing the cumualtive totals.
KH11NDR，
Please check attached PBIX file.
Regards,
Lydia
- KH11NDR
Thank you, I'll use that as my suggestion, I know where I was going wrong now, I was using my Master Calendar Months for the column and not the date field from my table.
Thanks again, I'm pretty sure I'll be needing more help, Im an X QlikView