Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Time diff from different rows based on name e day (Hours worked)

Hi there,   I have to build a dax measures to calculate the worked time of each employee. The challenge here is that the data is saved by a sequence of input that the employee saves his timesheet i...
Need Help
Tips and Tricks
  • Portrek's avatar
    Portrek
    5 years ago

    Hello fabinishi1207

     

    Try this measure below

     

    TimeWork =

    VAR DATEDIFF = DATEDIFF(MINX(Table,Table[Start time]),MAXX(Table,Table[End Time]),MINUTE)


    return

    DATEDIFF
     
     
    Best Regards
Portrek's avatar
Portrek
Resolver III
5 years ago

Hello fabinishi1207

 

Try this measure below

 

TimeWork =

VAR DATEDIFF = DATEDIFF(MINX(Table,Table[Start time]),MAXX(Table,Table[End Time]),MINUTE)


return

DATEDIFF
 
 
Best Regards
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Portrek,

 

Thanks for the feedback but unfortunately it didn't work as expected.