Calculate AVG Session time

[Anonymous]

Hi,

I have a table with the date and time for each SessionID
I need to calculate how long is each session? (AVG session time)

How is possible without add new columns?

TNX

[amitchandak · Accepted solution]

@Anonymous , You can create a new measure like

averageX(summarize(Table, Table[ga_session_id] , "_1", min(Table[event_timestamp]) , "_2", max(Table[event_timestamp])), datediff(_1,_2,second))

Now you can filter in Min and max for event name.

In place of second you can use minute , hour etc