Sales cumulated by date (Calculated Column)

[qwertzuiop]

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 😊

[themistoklis · Accepted solution]

Hello @qwertzuiop 

Try the following formula:

Cumulative_Sales =

CALCULATE (

SUM ( Sheet1[Sales] ),

FILTER( ALLEXCEPT( Sheet1,Sheet1[Product] ),

Sheet1[Date] <= MAX( Sheet1[Date] ))

)

File attached: