Show A Saturday as IsWorkday if Worked

[rahul_ferns]

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 show that as a workday

What and how do I edit the below to show any saturdays that were worked as IsWorkday

IsWorkday = IF(OR('Calendar'[Day of Week]=0,'Calendar'[Day of Week]=6),0,IF(ISBLANK('Calendar'[Holiday]),1,0))

Can I add 

Please point me in the right direction

Thanks

Rah

[amitchandak · Accepted solution]

@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)

[rahul_ferns]

@amitchandak 

Perfect solution

Thank you very much

Regards

Rah