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,

 

Thank you for replying. Yes, minute level is accurate enough. I am not very competent with DAX so could you elaborate on how to exactly use those functions in my situation?

 

I noticed that I probably wasn't as clear as I could have been in my original post so I apologize for that. Here is a simplified table that hopefully clarifies what I am trying to accomplish.

 

  • ERD's avatar
    ERD
    Community Champion
    5 years ago

    Hello Anonymous ,

    There is already a solution similar to your case that can be found here.

    In your case just use DATEDIFF function in RETURN part with MINUTE as interval.