Forum Discussion
Super UserNeed help in calculating Avg Duration Session
Hi Power BI Community,
I have to calculate Avg Session Duration per Users in power bi desktop. I have to divide the Avg Session Duration column to Users column.
And, data type of Avg Session Duration is in hh:mm:ss format and Users column in Whole number.
While dividing Avg Session Duration with Users so getting incorrect format.
Any lead would be really appreciated.
Convert to timestamp to second, take avg and convert it back
Refer
https://community.powerbi.com/t5/Desktop/Extracting-total-seconds-from-timestamps/td-p/190560
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
4 Replies
- TomMartens
Hey,
please provide sample data, upload the pbix and or xlsx file to onedrive or dropbox and share the link.
Regards,
Tom
Tahreem24Hi TomMartens ,
Could you please manage by using below screen shot? I cant upload file here because it has confidential data.
HI Tahreem24 ,
Current power bi does not support to do aggeration on date or time fields, you can consider adding a calculate column with specific DateTime range to group your records. After these, you can do aggregation on your records based on new group column. (e.g. 10 second per period, convert session durations to count of period)
Regards,Xiaoxin Sheng
- amitchandak
Convert to timestamp to second, take avg and convert it back
Refer
https://community.powerbi.com/t5/Desktop/Extracting-total-seconds-from-timestamps/td-p/190560
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
