Cumulative graph not working for previous year

[Anonymous]

Hi there,

I have the following graph on my report which looks at cumulative sales for 2019, with the black line supposed to show cumulative sales for the previous year. However, the black line is just showing month to month sales.

The blue line (current year) uses the following formula:

RunningSalesTotal =
CALCULATE(
('key_measure'[Total_sales]),
FILTER (
ALLSELECTED('salesorders'),
'salesorders'[createdon] <= MAX('salesorders'[createdon] )
)
)

I'm then using this formula to try and apply the previous year cumulative, but it's not working:

PY Cumulative = 
CALCULATE ( [RunningSalesTotal], DATEADD ( 'DIMDate'[Date], -1, YEAR ) )

Any ideas much appreciated?

Thanks

[amitchandak · Accepted solution]

For only year cummulative , use measures like

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date])))

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year)))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year))))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

Spot on, thanks