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.
Hello,
I have the employees arrival and departure time. I want to have a measure which can show the time spend for each day like below picture. As if he arrived and 6 times in a day and departed 6 times it should show the total time spent for each day. Is it possible to achieve it. Kindly help in this regard. Picture is attached for better understanding.
Thanks
Solved! Go to Solution.
@Junaid11 , You can create a new column
datediff([De_arrTime], [De_detime], second)
Then you can sum it. and later convert it to time for display
Duration
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...
@Junaid11 , You can create a new column
datediff([De_arrTime], [De_detime], second)
Then you can sum it. and later convert it to time for display
Duration
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |