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.
Please suggest some solution which may not increase the lines (Records) too much.
Attached file has just small table of source data as a sample. My actual data is in SQL and has many columns and rows.
Thanks and regards in advance.
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.
Please suggest some solution which may not increase the lines (Records) too much.
Attached file has just small table of source data as a sample. My actual data is in SQL and has many columns and rows.
Thanks and regards in advance.