Hi, how to calculate the cumulative sales for total selected months in descending order by Country, Company and SKU? Below is the sample data.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.