Forum Discussion

BrandonL's avatar
BrandonL
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Calculating Duration from 2 tables

I have 2 tables: First contains Start Time Second Contains End Time How do i calculate the duration between these times using 2 unique id pivots: Session_ID & Player_ID as each "session" will ha...
  • ibarrau's avatar
    ibarrau
    6 years ago

    Hi. How is the relationship between the tables?

    If you have a 1-1 then you have no problem you can do two things, merge them together or create a column in table 1 like:

    DATEDIFF ( Table1[StartDate]; RELATED(Table2[EndDate]); HOUR )

    You can use datediff to get any interval of time you want.

     

    If you have 1-* we should talk again, let us know the relationship.

    Regards,