Show sales YTD and the same for last year also

Hey guys,

I did a line and clustered column chart to show sales from 2011 to 2016. But I need to know how to show all sales of the current year and the previous years (2011-2015). The problem is that I don’t have the intact sales of 2016, so I want to compare sales YTD of 2016 and sales YTD of 2015 comparing 2016 in the same chart.

Someone suggested to use forecasting, but I’m ruling it out in this case. Anyone here have another suggestion?

Thanks in advance!

Hi there,

You could use SAMEPERIODLASTYEAR and TOTALYTD functions:

Total Sales = SUM(Sales[SALE]) 

Total Sales YTD = TOTALYTD(Sales[Total Sales],'Sales'[DATE]) 

Total Sales YTD Last Year = CALCULATE([Total Sales YTD],SAMEPERIODLASTYEAR('date'[date])) 

Then create a table to display the results, and create a Line and Clustered Column Chart.

Just also make sure you are using a date table as well. You always need one especially if you are using time intelligence functions.