Please help me with this formula. I know I need to create a table containing my holidays and link the table to my date table. How do I write the dax formula to put a 0 in all weekends and holidays?

Yes, I am embarrassed to even show you my work around.

WorkingDays =

IF (

OR ( DateDimension[DayOfWeek] = 7, DateDimension[DayOfWeek] = 1 ),

0,

IF (

DateDimension[Date] = VALUE ( β01/01/2018β ),

0,

IF (

DateDimension[Date] = VALUE ( β01/02/2018β ),

0,

IF (

DateDimension[Date] = VALUE ( β03/30/2018β ),

0,

IF (

DateDimension[Date] = VALUE ( β05/28/2018β ),

0,

IF (

DateDimension[Date] = VALUE ( β07/04/2018β ),

0,

IF (

DateDimension[Date] = VALUE ( β09/03/2018β ),

0,

IF (

DateDimension[Date] = VALUE ( β11/22/2018β ),

0,

IF (

DateDimension[Date] = VALUE ( β11/23/2018β ),

0,

IF (

DateDimension[Date] = VALUE ( β12/25/2018β ),

0,

IF (

DateDimension[Date] = VALUE ( β12/26/2018β ),

0,

IF (

DateDimension[Date] = VALUE ( β01/02/2017β ),

0,

IF (

DateDimension[Date] = VALUE ( β04/14/2017β ),

0,

IF (

DateDimension[Date] = VALUE ( β05/29/2017β ),

0,

IF (

DateDimension[Date] = VALUE ( β07/04/2017β ),

0,

IF (

DateDimension[Date] = VALUE ( β09/04/2017β ),

0,

IF (

DateDimension[Date] = VALUE ( β11/23/2017β ),

0,

IF (

DateDimension[Date] = VALUE ( β11/24/2017β ),

0,

IF (

DateDimension[Date] = VALUE ( β12/25/2017β ),

0,

IF (

DateDimension[Date] = VALUE ( β12/26/2017β ),

0,

IF ( DateDimension[Date] = VALUE ( β12/31/2017β ), 0, 1 )

)

)

)

)

)

)

)

)

)

)

)

)

)

)

)

)

)

)

)

)