topic Re: Compare Easter Weeks every Year in DAX Commands and Tips

Compare Easter Weeks every Year

Sidpug2013 — Mon, 27 May 2024 08:16:37 GMT

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

Every Year the Easter Weeks changes, and i don't know as to do. The comparison needs to be done with the previous year.

Thanks in advance

Re: Compare Easter Weeks every Year

lbendlin — Tue, 28 May 2024 00:58:39 GMT

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.

Re: Compare Easter Weeks every Year

Sidpug2013 — Tue, 28 May 2024 10:34:46 GMT

I must compare sales about:

- Previous week of Easter Week

- Easter Week

- Following Week of Easter Week

How can i do with Dax?

Re: Compare Easter Weeks every Year

lbendlin — Tue, 28 May 2024 12:05:56 GMT

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.