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...
lbendlin's avatar
lbendlin
Super User
5 years ago

One quick question - what datetime locale is that data from?

Also - do you need this as a measure or is a calculated column enough ( I assume it is)?

 

 

 

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".