Get Same Week Ending Prior Year Using DAX

[DataSundowner]

Hello everyone. I'm trying to get same week ending (Sunday) of prior year for each week. I get it to work using the following, but it only works for date goes back to 1/9/2022. If I bring in the weekending date of 1/2/2022, the formula that looks for same week prior year will fail. It gives an error saying "a table of multiple values was supplied where a single value was expected". 1/2/2022 is technically the 52th week of 2021 by ISO standard, so I would like the formula to return the Sunday of 52th week of 2020 which is 12/27/2020. I have the date dimension table that maps each date to ISO year and ISO week number. How can I fix this? Thank you in advance! 

[lbendlin · Accepted solution]

The best way to fix this is not to attempt to compute it.  Use a static calendar table that has all the required columns predefined.