Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sidpug2013
Regular Visitor

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

 

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

1 ACCEPTED SOLUTION

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.

View solution in original post

3 REPLIES 3
Sidpug2013
Regular Visitor

I must compare sales about:

- Previous week of Easter Week

- Easter Week

- Following Week of Easter Week

How can i do with Dax?

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
Super User
Super User

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.