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/2016"),0,if(DateDimension[Date] = value("05/30/2016"),0,if(DateDimension[Date] = value("07/04/2016"),0,if(DateDimension[Date] = value("09/05/2016"),0,if(DateDimension[Date] = value("11/24/2016"),0,if(DateDimension[Date] = value("11/25/2016"),0,if(DateDimension[Date] = value("12/23/2016"),0,if(DateDimension[Date] = value("12/26/2016"),0,if(DateDimension[Date] = value("12/30/2016"),0,1)))))))))))
I of course hate this for obvious reasons. I have a holiday and a datedimension table.
The holiday table has the holidays in it so I think I need to use the RelatedTable function somehow. Any suggestions?
Thanks for your help.
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?
1 Reply
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?