Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How can I track multiple time differences simultaneously based on another column?

Hi all,   I need help in tracking multiple smiultaneous timestamps.   I have a simple table like the one attached. Table with columns Person ID, Time, Worktype and Index   This is a table that...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

Times are Eastern European Standard Time and a calculated column is exactly what I'm looking for.

lbendlin's avatar
lbendlin
Super User
5 years ago

Then the DAX I posted should work. Adjust it to your actual table name.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    It works perfectly! Thank you very much!

     

    I also need to calculate duration when the person is working on any position. Should I make a separate forum post on this? 

     

    I updated the sample date. What I need to calculate is the data in the "Working time" column.

     

    Excel 

     

    Each entry has its own ID number ("ID column") so this can be used and when positions are combined, they get the same ID number. I need to calculate everything else except "OFFWORK", "BREAK" and "OFFICE".