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.
Hi,
I am trying to show the cumulative net sales but as you look at the date, the numbers are in descending order. It should be in ascending order because after each date the sales numbers increase. Is there a formula to fix this?
Solved! Go to Solution.
Hi @Anonymous ,
Use the following measure to calculate the cummultive Sales:
Measure= CALCULATE([New Sales - Actual CP ], FILTER(ALLSELECTED(Dim InvoiceDate [Invoice_Date]), Dim InvoiceDate [Invoice_Date] <= MAX(Dim InvoiceDate [Invoice_Date])))
Mark this as a solution, if I answered your question. Kudos are always appreciated.
Thanks!
Hi @Anonymous ,
Use the following measure to calculate the cummultive Sales:
Measure= CALCULATE([New Sales - Actual CP ], FILTER(ALLSELECTED(Dim InvoiceDate [Invoice_Date]), Dim InvoiceDate [Invoice_Date] <= MAX(Dim InvoiceDate [Invoice_Date])))
Mark this as a solution, if I answered your question. Kudos are always appreciated.
Thanks!
God blessssssssss you!!!!!!!!!!
I need to have you on speed dial 😋
Happy to help!
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |