Comparing values from last period when date is always different using slicers before and after

Hello,

I have 3 tables:

1) date table

2) holiday table that is linked to the date table

3) the value table.

The value (SRT) table looks like this.

 The table with dates going back 3 years along with it's values.

The objective is to compare any year to any prior year during the holidays, more specifically because Thanksgiving lands on a different day, I have slicer with the from the Holiday table, so that I can choose Thankgiving for example, then it'll automatically compare the values Thanksgiving from say 2019 to 2020.  Furthermore, I can adjust the before and after timespan so if I choose one day before Thanksgiving, and 1 day after thanksgiving, i'd get a sum of the 3 days so I can compare 2019 to 2020 for the 3 days. 

My Problem is that no matter what I do, my values are all summed together on 11/28/2019, 11/26/2020.  I want that value for the prior day, day of Thanksgiving, and day after separately on each date line(for each year)

Someone helped me out with this:

Holiday Between=

var HolStart1 = min('HOLIDAYS-1'[Date]) - 'Days Before'[Days Before Value]

var HolEnd1 = MIN('HOLIDAYS-1'[Date]) + 'Days After'[Days After Value]

return CALCULATE(sum('SRT'[Value]),

AND(SRT[Date]>= HolStart1,

SRT[Date]<= HolEnd1)

)

 

Heres what It looks like:

 

 

Thank you all.

MIke