Forum Discussion

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive 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?  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!

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

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper 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!!