cancel
Showing results for
Did you mean:  Sales 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 😊

1 ACCEPTED SOLUTION  Super User

Hello @qwertzuiop

Try the following formula:

Cumulative_Sales =
CALCULATE (
SUM ( Sheet1[Sales] ),
FILTER( ALLEXCEPT( Sheet1,Sheet1[Product] ),
Sheet1[Date] <= MAX( Sheet1[Date] ))
)

File attached:  Super User

Hello @qwertzuiop

Try the following formula:

Cumulative_Sales =
CALCULATE (
SUM ( Sheet1[Sales] ),
FILTER( ALLEXCEPT( Sheet1,Sheet1[Product] ),
Sheet1[Date] <= MAX( Sheet1[Date] ))
)

File attached:   