Forum Discussion

New Member

5 years ago

Solved

Calculate the Average Time Spent Viewing a Page

Hello all, I'm trying to calculate the average time spent viewing a web page. I have a column with the average time spent viewing a web page in a text format as '00:00:00'. Id like to claculate th...

v-lionel-msft
5 years ago
Hi TDog ,

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Calculate the Average Time Spent Viewing a Page.pbix30 KB

Icon for Super User rank

Super User

5 years ago

TDog , You can split this and convert in second and take avg

time in second = left([Avg time on page],2)*3600 + mid([Avg time on page],4,2)*60 + right([Avg time on page],2)

else refer

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389