Inconsistent holiday

[Anonymous]

Background: 

The company took the following holidays for 2018 - 

• New Year’s Day (Jan 1)
• Presidents’ Day (Feb 19)
• Memorial Day (May 28)
• Independence Day (July 4)
• Labor Day (Sept 3)
• Thanksgiving Day & day after (Nov 22 & 23)
• Christmas Eve & Christmas Day (Dec 24 & 25)
• New Year’s Eve (Dec 31)

However, in previous years, the Presidents' Day was NOT a holiday and MLK Day WAS a holiday.

I have a date table which contains all dates and corresponding holiday names with dates.I also have all the weekdays with 0=Sunday, 1=Monday, etc.  I would like to create a new column that is True False for working day vs. nonworking day. How do I create a column that reflects all years? 

[Anonymous · Accepted solution]

Create a new table called holiday to store the holiday information such as below.

Create relationship between the holiday table with your original calendar table.

Then use the following Dax to create a calcuated column to mark the working days

Isworkingday = IF('Calendar'[Weekday]>0&&'Calendar'[Weekday]<6&&COUNTX(RELATEDTABLE(Holiday),1)<1,"Yes","No")