topic Re: The AVERAGE time between pages in sessions in DAX Commands and Tips

The AVERAGE time between pages in sessions

Anonymous — Wed, 27 Jan 2021 08:12:31 GMT

Hi,
I created summarize a table like this:

Now, I need to calculate measure with AVG time between pages in each session
That is,
First-page entry: 13:38:18
Second-page entry : 13:52:31
So the difference between these times is the time between two pages......

How it possible?

Re: The AVERAGE time between pages in sessions

amitchandak — Wed, 27 Jan 2021 08:51:05 GMT

Anonymous , Create a new column like

diff duration between page= [session_start_time] - maxx(filter(Table, [session_id] =earlier([session_id]) && [start_time] <earlier([start_time])),[start_time])

Re: The AVERAGE time between pages in sessions

Anonymous — Wed, 27 Jan 2021 16:35:51 GMT

Thanks for the reply, amitchandak
I need to make this a measure, not as a custom column
So I cant to add this column to the temporary table in measure

Re: The AVERAGE time between pages in sessions

amitchandak — Thu, 28 Jan 2021 17:24:01 GMT

Anonymous , Try measuere like

diff duration between page= max([session_start_time]) - maxx(filter(allselected(Table), [session_id] =max([session_id]) && [start_time] <max([start_time])),[start_time])

averagex(summarize(Table, Table[seesion_id], table[Page], table[start_time], "_1", datediff(max([session_start_time]) , maxx(filter(allselected(Table), [session_id] =max([session_id]) && [start_time] <max([start_time])),[start_time]),minute)),[_1])