How Many Working Days Has An Employee Been Off Work?
I answered some forum questions recently that were similar in nature and I thought they would make a good blog article. The scenario is this: there is a table that contains information about when an employee was absent from work like shown below.
The question is “How many working days were they off work giving consideration to both weekends and public holidays?”.
The trick to solving this problem is to create a good quality calendar table and use the calendar table to validate the days off. I explain the process below.
Tags: dax