Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 😊
Solved! Go to Solution.
Hello @qwertzuiop
Try the following formula:
Hello @qwertzuiop
Try the following formula:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |