Forum Discussion

sraj's avatar
sraj
Responsive Resident
2 years ago
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...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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's avatar
rajendraongole1
Super User
2 years ago

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!!