How to find time passed in a series of records

[thatalexboyd]

Hey, I am trying to find the time passed between two events in a series of data. The series are defined by a session_id that is the same for all events. I know I wanty to order the data then fid the differnece between the first and last, but I am not sure how. Whenever I start with an index column it wants to index each opne in order, not the group. Any help would be great, and a sample of data is below.

[amitchandak · Accepted solution]

@thatalexboyd , You can create a measure like

averageX(values(Table[session ID]), datediff(Min(Table[eventtime]),max(Table[eventtime]),second))

[thatalexboyd]

So I adjusted the above measure and it looks like it is working! I guess a follow up question, how does an AverageX accomplish this since it a difference?