Cumulative graph not working for previous year

Question

Hi there,&nbsp;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.&nbsp;&nbsp;The blue line (current year) uses the following formula:&nbsp;RunningSalesTotal = CALCULATE(('key_measure'[Total_sales]),FILTER (ALLSELECTED('salesorders'),'salesorders'[createdon] &lt;= MAX('salesorders'[createdon] )))&nbsp;I'm then using this formula to try and apply the previous year cumulative, but it's not working:&nbsp;PY Cumulative =&nbsp;CALCULATE ( [RunningSalesTotal], DATEADD ( 'DIMDate'[Date], -1, YEAR ) )&nbsp;Any ideas much appreciated?&nbsp;Thanks

amitchandak · Accepted Answer

For only year cummulative , use measures like&nbsp;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))))&nbsp;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-with-Winners/ba-p/890814https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739 https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Forum Discussion

Cumulative graph not working for previous year

2 Replies

Related content

Cumulative Total

Cumulative sales previous year in Stock running

Cumulative Sales for Full Previous Year

Creating Cumulative Graphs

Previous month not working