Working days - mark one of Sunday as working day

[ToKo]

Hi,

I have such case.

In calendar table i have Workday column which is calculated by below DAX:

Workday = IF (('Calendar'[DayOfWeek]= "Sunday" || ('Calendar'[DayOfWeek]= "Saturday") ,0,1)

Is it possible to mark one of Sunday (2021-11-06) as a exeption and counting as 1 not 0 ?

[PaulOlding · Accepted solution]

Hi @ToKo 

Sure.  Nested IF statements are evaluated in order, so we can check for 2021-11-06 first, then check for Saturday/Sunday:

Workday = 
IF('Calendar'[Date] = DATE(2021,11,6), 
    1,
    IF(('Calendar'[DayOfWeek]= "Sunday" || 'Calendar'[DayOfWeek]= "Saturday"),0,1)
)