Forum Discussion
Working days
This is my current formula: WorkingDays = IF (OR (DateDimension[DayOfWeek] = 7, DateDimension[DayOfWeek] = 1), 0, if(DateDimension[Date] = value("01/01/2016"),0,if(DateDimension[Date] = value("03/25...
Perhaps you could consider doing a Merge query in the query editor with the appropriate join (left anti?) to essentially filter out your holidays from your DateDimension table?
Perhaps you could consider doing a Merge query in the query editor with the appropriate join (left anti?) to essentially filter out your holidays from your DateDimension table?