Cumulative sales monthly and yearly

[Anonymous]

Hi,

I want to create a chart which shows the cumulative sales of an order table with the month on the axis and my year on the legend.

Currently, I have the following formula to calculate the cumulative 

Cumulative sales = CALCULATE(SUM(orders[Sales Value]);FILTER(ALL('Date');'Date'[Date] <= MAX('Date'[Date])))

But when I create the visual. I get this:  

So it should reset every year but instead continues to count.

Any help?

[v-yuta-msft · Accepted solution]

Hi muren,

Modify your measure using DAX below and check if the issue can be resolved:

Cumulative sales =
TOTALYTD ( SUM ( orders[Sales Value] ), Date[Date] )

Regards,

Jimmy Tao

[Anonymous]

Thank you, it was the solution I searched for

[mwegener]

Hi @Anonymous

use the Quick measure "Year-to-date total".