Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Ram,

My dataset is different than the dataset mentioned in the vedio.

I dont have log in and log out time in the same row.