Bounce rate, page exit rate, time difference between first and next page(different from 1st page)

[MS2507]

Hi All,

I'm new to powebi. Can someone help me to calculate bounce rate, exit rate and time difference between first and last visited page. 

I have added rank based on userid.  Please refere attached screenshot for sample data.

[Anonymous]

Hi @MS2507 ,

It is recommended that you use DAX to calculate.

Can you provide some of your specific expected results?

Based on the sample data you give, what the expected result is.

To calculate the time difference, we often use DATEDIFF function.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MS2507]

Hi,

I want to calculate bounce rate= (Sessions where users leaving page in <=1min)/Total sessions. I'm expecting below results. where first and next page should not be the same.

User	First_Page	First_DateTime	Seq_No1	Next_Page	Next_DateTime	Seq_No2	Diff(Min)
1	a	2/08/2022 17:49	1	b	2/08/2022 17:49	2	0
2	a	28/07/2022 19:01	1	b	28/07/2022 19:01	2	0
2	b	28/07/2022 19:01	2	a	28/07/2022 19:03	3	2
2	a	28/07/2022 19:03	3	b	28/07/2022 19:12	4	9
2	b	28/07/2022 19:34	6	a	28/07/2022 19:46	7	12