Issue with DAX SamePeriodLastYear

[Jubjab]

I have a Power Pivot file with sales data, and I follow last week's sales to the previous year's sales. I have a function called "Previous year's sales" which is defined as

=CALCULATE([Total Sales];SAMEPERIODLASTYEAR('Calendar'[Date]))

This has worked fine, but now when I added 2022 to the calendar and try to change the year to 2022 in the report I get the error "only works with contiguous date selections". The Calendar is defined as a calendar table and I added 2022 using the define dates wizard. Everything works fine if I switch between 2020 and 2021 but 2022 gets that error.

Any idea what this could be due to?

 

[RoryA]

Could be a few things - perhaps this: Defanging the “contiguous date selections” error - P3 Adaptive

 

[Jubjab]

Thanks, I tried that but unfortunately didn't work. And actually now I notice that I get the same error if I select week 1 of 2021 so clearly that is causing the issue, i.e. when the week spans over 2 years (using the ISO week).