topic Re: DAX formula for cumulative sales in the correct sorting order in DAX Commands and Tips

DAX formula for cumulative sales in the correct sorting order

Anonymous — Wed, 15 Sep 2021 12:20:51 GMT

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?

Re: DAX formula for cumulative sales in the correct sorting order

Tanushree_Kapse — Wed, 15 Sep 2021 12:10:53 GMT

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!

Re: DAX formula for cumulative sales in the correct sorting order

Anonymous — Wed, 15 Sep 2021 12:20:31 GMT

God blessssssssss you!!!!!!!!!!

I need to have you on speed dial 😋

Re: DAX formula for cumulative sales in the correct sorting order

Tanushree_Kapse — Wed, 15 Sep 2021 12:23:41 GMT

Happy to help!