I need help for employees attendance report built by pivot table on check in and check out data.
I have used power query and added some custom columns to calculate Present and Absent employees. Also created calendar and employees list tables in data model and created relationships between tables.
Please see attachment. Pivot table should show absent for the employee whose presence is not in source data.
Please help and guide me that what Am I missing?
Please suggest some Custom Column / Calculated Column / Measure etc for desired result.
Thanks and regards in advance.
Bookmarks