Forum Discussion
rahul_ferns
Helper II
Helper IIShow A Saturday as IsWorkday if Worked
Hi Experts I have a IsWorkday column in my Calendar table which shows days that are working day and excluded holidays (Works perfectly) From time to time, we work on some saturdays and I want to sh...
rahul_ferns , Add working Saturday flag and have new column like
Switch( True(),
'Calendar'[Day of Week] =0, 0,
not(ISBLANK('Calendar'[Holiday])) , 0,
'Calendar'[Day of Week]=6 && isblank([Working Saturday]), 0, 1)
amitchandak
Super User
Super Userrahul_ferns , Add working Saturday flag and have new column like
Switch( True(),
'Calendar'[Day of Week] =0, 0,
not(ISBLANK('Calendar'[Holiday])) , 0,
'Calendar'[Day of Week]=6 && isblank([Working Saturday]), 0, 1)
rahul_ferns