Forum Discussion
Total Break Time for Employees
Hi Team,
I have a dataset containing the biometric time of each employees:
I need to calculate the total break time for each employees. There are multiple entry and exit time for each employee for a day.
Break time should be calculated as : (each Log out time - Immediate next log in time),
Please help.
Thanks
Amit
Hi Anonymous ,
Try this column:
Break time = var _f = TOPN(1,FILTER('Table',[Date & Time]>EARLIER('Table'[Date & Time])&&[User ID]=EARLIER('Table'[User ID])),[Date & Time],ASC) VAR _S = MAXX(_f,[Date & Time]) VAR _D = IF(ISBLANK(_S),0,DATEDIFF([Date & Time],_S,MINUTE)) RETURN IF([Event Type]="LOGIN",0,_D)Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- v-chenwuz-msft
Community Support
Hi Anonymous ,
Try this column:
Break time = var _f = TOPN(1,FILTER('Table',[Date & Time]>EARLIER('Table'[Date & Time])&&[User ID]=EARLIER('Table'[User ID])),[Date & Time],ASC) VAR _S = MAXX(_f,[Date & Time]) VAR _D = IF(ISBLANK(_S),0,DATEDIFF([Date & Time],_S,MINUTE)) RETURN IF([Event Type]="LOGIN",0,_D)Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Shreeram04Resolver III