Forum Discussion
Calculated Table for Work Hours
The straight answer is "you don't".
I think you could "unpivot other columns" (in Power Query) from the employee id in each table and get yourself some columnar data like
emp_id date time_in
You could probably 'Merge as New' and join both tables on date and employee id.
That'll give you a table with emp_id date time_in time_out and you can use your DATEDIFF function to add another column.
The straight answer is "you don't".
I think you could "unpivot other columns" (in Power Query) from the employee id in each table and get yourself some columnar data like
emp_id date time_in
You could probably 'Merge as New' and join both tables on date and employee id.
That'll give you a table with emp_id date time_in time_out and you can use your DATEDIFF function to add another column.
Thanks so much HotChilli! That makes a lot of sense!!