Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |