Compare same special day(Christmas day) in different years

[jlarques]

Hello everybody,

someone knows how can I compare a special day like Christmas, New Year, etc with the same day in different years? I'm interested to know information like sales, number of people, etc and I don't know which is the good formula.

Thanks for your help!

BR,

Jose Luis

[jlarques]

Hello Charlie,

thank you so much for your solution! It's exactly that I need it!

Thanks again.

BR,

Jose Luis

[v-caliao-msft · Accepted solution]

@jlarques,

Create a calculated column in your date table.

Column =
IF (
    MONTH ( 'Date'[Date] ) = 12
        && DAY ( 'Date'[Date] ) = 25,
    "Christmas Day",
    IF ( MONTH ( 'Date'[Date] ) = 1 && DAY ( 'Date'[Date] ) = 1, "New Year", "N/A" )
)

And then use this column in a slicer visual.

Regards,

Charlie Liao