Hard coded days as working days column

[sraj]

Hi everyone,

I am trying to show certain days on this column as working day, but it keeps showing as weekend.  Can someone advise on how I can correct this to show these days as a working day?  Please advise.

WorkingDay 2 =
SWITCH(
TRUE(),
ISBLANK('Calendar'[HolidayColumn]) && 'Calendar'[Day of week] <= 5, "working day",
ISBLANK('Calendar'[HolidayColumn]) && 'Calendar'[Day of week] >= 6, "weekend",
'Calendar'[Date] = DATE(2024, 6, 22) || 'Calendar'[Date] = DATE(2024, 6, 29) || 'Calendar'[Date] = DATE(2024, 7, 13) || 'Calendar'[Date] = DATE(2024, 7, 20), "working day",
"Holiday"
)

Thank you!

[sraj]

@rajendraongole1 - that worked, thank you so much!!

[rajendraongole1 · Accepted solution]

Hi @sraj - slight adjustment of your calculation as below:

WorkingDay 2 =
SWITCH(
TRUE(),
'Calendar'[Date] = DATE(2024, 6, 22) ||
'Calendar'[Date] = DATE(2024, 6, 29) ||
'Calendar'[Date] = DATE(2024, 7, 13) ||
'Calendar'[Date] = DATE(2024, 7, 20), "working day",

ISBLANK('Calendar'[HolidayColumn]) && 'Calendar'[Day of week] <= 5, "working day",
ISBLANK('Calendar'[HolidayColumn]) && 'Calendar'[Day of week] >= 6, "weekend",
"Holiday"
)

Hope it works

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!