Forum Discussion
Solved
YoY on a graph
I am trying to create a year on graph from the following tables Table 1: DateDim Table 2: Sales I will have the date on the datedim filter set as follows and the g...
Your previous year measure would be something like this
PY Sales = CALCULATE(SUM(Sales[Count]),DATEADD(Dim_date[Date],-1,year))
You can create this with measures or you can use the month and days as the axis (without year) and use year as the legend.
The issue I have with this method is that because the date filter only shows May 01/05/2023 - 21/05/2023 then it will filter out the line from previous year. Because of this, I think it is best to use a measure. Could you please assist?