The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi, how to calculate the cumulative sales for total selected months in descending order by Country, Company and SKU? Below is the sample data.
https://drive.google.com/file/d/1QSxBcandDoIpdo4aA4uAkrIfpC0YNwSY/view?usp=sharing
For example, I select Jan to Dec 2023, the cumulative sales should calculate the total sales in descending order.
After calcuting the cumulative sales, I need to categorize the SKU in ABC category. The logic is as below:
Expected output (in red):
Solved! Go to Solution.
Hi,
Please find attached my solution file.
Hope this helps.
You are welcome.
@PBI_newuser , Refer if this can help
Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
78 | |
70 | |
52 | |
50 |
User | Count |
---|---|
120 | |
120 | |
76 | |
62 | |
61 |