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