weekly comparison YOY with holidays

[477885wk]

I will drop 3 measures into a line graph for 2017, 2018, 2019 sales. Then I will have a slicer for weeks offset, and have it by default be set to -1 to +1. So that every time you refresh, the graph is showing you last week, this week, next week for the last 3 years. 

But holiday weeks are very relevant to my sales. So if it's a holiday today, I don't want to compare to the same week of last year, I want to compare to whatever week the holiday happened. So maybe it's week6 in 2019, week7 in 2018, week5 in 2016. The graph needs to adjust to show the current week for this year, but the relevant holiday weeks for the previoius years. 

I need the line graph to be easilly comparable based on relevant past weeks, not on literal same weeks. 

[v-shex-msft]

HI @477885wk ,

Can you share some sample data and expected result for test? It is hard to test and coding formula without any sample data.

Regards,

Xiaoxin Sheng