cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Responsive Resident

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

1 ACCEPTED SOLUTION
Super User

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!

Proud to be a Super User!

2 REPLIES 2
Responsive Resident

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

Super User

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!

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors