Forum Discussion
Calculate diff time based on different rows
Hi Guys,
is it possible to calculate the time diff based on different rows?
| ID | Time Register | Name | Place of work | Starting or finishing work? |
| 1 | 7/1/21 8:03 | John | Home | Starting |
| 2 | 7/1/21 8:10 | Ahbra | Home | Starting |
| 3 | 7/1/21 8:20 | Elisa | Home | Starting |
| 4 | 7/1/21 15:10 | Elisa | Home | Finishing |
| 5 | 7/1/21 16:00 | John | Home | Finishing |
| 6 | 7/1/21 13:00 | Abhra | Home | Finishing |
| 7 | 7/1/21 8:25 | John | Office | Starting |
| 8 | 7/1/21 8:03 | Elisa | Home | Starting |
| 9 | 8/1/21 13:20 | John | Office | Finishing |
| 10 | 8/1/21 13:03 | Elisa | Home | Finishing |
For example
I need to john how many hours John worked from home and from the office.
Thank you
This is quite hard in DAX. But I recorded a video a few years ago showing how you can do it in Power Query https://youtu.be/xN2IRXQ2CvI
2 Replies
This is quite hard in DAX. But I recorded a video a few years ago showing how you can do it in Power Query https://youtu.be/xN2IRXQ2CvI
Hi,
On the same day, how can Elise have 2 starting points from Home (ID 3 and 8). Please check your data. Also, please maintain the same spelling of Ahbra. Share data after thoroughly checking.
