cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qwertzuiop
Advocate II
Advocate II

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.

 

DateProductSalesSales (cummulated)
01.01.2021A2020
01.02.2021A1030
01.03.2021A5080
A
01.01.2021B55
01.02.2021B2025
01.03.2021B1540
B 
01.01.2021C6060
01.02.2021C2080
01.03.2021C30110
C

 

Any ideas how to achieve?

 

Thank you very much for your contribution.

 

Cheers

qwertzuiop 😊

1 ACCEPTED SOLUTION
themistoklis
Super User
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:

View solution in original post

1 REPLY 1
themistoklis
Super User
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:

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors