Forum Discussion
NewbieJono
Post Partisan
Post PartisanWorking day, not include Bank Holiday or Weekend
i am trying to add a marker in my table to say if its a working day. this code does not seem to work. i think its the line regarding bank holiday IsWorkingDay = IF
(NOT('DIM - Da...
HI NewbieJono,
I think the workday rule should be not the weekend and not included in the holiday table records, right? If that is the case, you can try to use the following formulas:
IsWorkingDay = IF ( WEEKDAY ( 'DIM - Date Table'[weekday], 2 ) < 6 && NOT ( 'DIM - Date Table'[Date] IN ALL ( 'DIM - Bank Holidays'[Date] ) ), 1, 0 )Regards,
Xiaoxin Sheng
parry2k
Super User
Super Userwhich side is one and which side is many? Why it would be one to many?