Forum Discussion

Sidpug2013's avatar
Sidpug2013
Frequent Visitor
2 years ago
Solved

Compare Easter Weeks every Year

Hi! I have Sales Table and Date Table (with holidays until 2050).   I wish to calculate and compare sales about: - Previous week of Easter Week - Easter Week - Following Week of Easter Week ...
  • lbendlin's avatar
    lbendlin
    2 years ago

    In your Date table you have a flag "Easter week"  for each participating day.  In your DAX use that flag as an additional filter when you do the year-over-year comparisons.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

In your Date table mark the Easter week for each of your years.  This data is immutable, there is not good reason to try and calculate it over and over again.