Forum Discussion
Solved
Calculating working days
Hello, I've read numerous threads on calculating working days, but still aren't getting it working at the moment.. I have: a date table (marked as date table) a column IsWorkingDay ...
v-robertq-msft , I think I've found it!
The date table and workingday column are the samen, but the working days delta has become the following:
as you can see, the one delayed shipment in the overview now gets a positive number. I should be able to use this to measure delayed shipments within a tolerance finally get the performance based on working days! :):):)
Don't do that (trying to use the weekday function). Use a proper external calendar table that you create and maintain manually and that has the actual workdays for your scenario, excluding holidays etc.