Forum Discussion
qwertzuiop
Advocate III
Advocate IIISales cumulated by date (Calculated Column)
Hello dear Power-BI-Community
Following Problem to solve:
Let's assume the table below as example with the following attributes (date, product, sales)
Needed is the column "sales cummulated" based on product and date as calculated column in Power BI.
| Date | Product | Sales | Sales (cummulated) |
| 01.01.2021 | A | 20 | 20 |
| 01.02.2021 | A | 10 | 30 |
| 01.03.2021 | A | 50 | 80 |
| … | A | … | … |
| 01.01.2021 | B | 5 | 5 |
| 01.02.2021 | B | 20 | 25 |
| 01.03.2021 | B | 15 | 40 |
| … | B | … | |
| 01.01.2021 | C | 60 | 60 |
| 01.02.2021 | C | 20 | 80 |
| 01.03.2021 | C | 30 | 110 |
| … | C | … | … |
Any ideas how to achieve?
Thank you very much for your contribution.
Cheers
qwertzuiop 😊
Hello qwertzuiop
Try the following formula:
Cumulative_Sales =CALCULATE (SUM ( Sheet1[Sales] ),FILTER( ALLEXCEPT( Sheet1,Sheet1[Product] ),Sheet1[Date] <= MAX( Sheet1[Date] )))File attached:
1 Reply
- themistoklis
Community Champion
Hello qwertzuiop
Try the following formula:
Cumulative_Sales =CALCULATE (SUM ( Sheet1[Sales] ),FILTER( ALLEXCEPT( Sheet1,Sheet1[Product] ),Sheet1[Date] <= MAX( Sheet1[Date] )))File attached: