Same period compare to a specific year

[liboyjoseph]

Hi team

Need your help on this please.

I want to create a mesure to compare same period to 2019. instead of same period last year, I need same period 2019. 

I've below measure and it works fine when my current date selection is on 2022, I want to compare all my dates to 2019.

Y3 = CALCULATE([Total Sales TY],DATEADD('Date'[Date], -3, YEAR)) 

[liboyjoseph]

Thank you @amitchandak Your solution work perfectly

[amitchandak · Accepted solution]

@liboyjoseph , if you always was 2019

Y3 =

var _diff = 2019 - maxx(allselected('Date'), 'Date'[Year]) )

//or var _diff = 2019 - year(maxx(allselected('Date'), 'Date'[date]) ))

return

CALCULATE([Total Sales TY],DATEADD('Date'[Date], _diff , YEAR))

[Gerlind]

Hi, I want to make a measure to compare every last 4 year to 2017, same period. 2017 is my reference year to calculate an evolution for 2018, 2019, 2020 ...