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.