Forum Discussion

NewbieJono's avatar
NewbieJono
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Working 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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

NewbieJono what is the relationship between Dim Date Table and Dim - Bank Holidays tables?

  • NewbieJono's avatar
    NewbieJono
    Icon for Post Partisan rankPost Partisan
    4 years ago

    one to many