Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculated Table for Work Hours

Hi everyone, I am new to DAX and have been playing around with this problem for a few days now. I have two tables with the same dimensionality of ~4000 rows (employees) by ~200 columns (dates). One ...
  • HotChilli's avatar
    HotChilli
    7 years ago

    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.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks so much HotChilli! That makes a lot of sense!!