Forum Discussion
Solved
Hard coded days as working days column
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? P...
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!!
@rajendraongole1 - that worked, thank you so much!!