Forum Discussion
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 the average time spent on each web page. There are multiple entires of like web pages with different time spent durations. My data columns are below: Any help you can provide is greatly appreciated. Many thanks!
Hi TDog ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
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 - v-lionel-msft
Community Support
Hi TDog ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.