Need help in calculating Avg Duration Session

[Tahreem24]

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.

[amitchandak · Accepted solution]

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

[TomMartens]

Hey,

please provide sample data, upload the pbix and or xlsx file to onedrive or dropbox and share the link.

Regards,

Tom

[Tahreem24]

Hi @TomMartens ,

Could you please manage by using below screen shot? I cant upload file here because it has confidential data.

[v-shex-msft]

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