Calculate Average Duration in hh:mm:ss

[spencer_g]

Hi everyone and thanks in advance for any insight you may have!

I am working with data from Google Analytics, and I have the lifetime average time that a user spends on our website in hh:mm:ss. I want to breakout that average by date and user type, but the resulting measure is a decimal number and I am unable convert that to a time format. 

Does anyone know of a way to go about doing this?

Thanks!

[Nhallquist]

Are you using the PowerBI Service, or did you build your report in PBI Desktop, then publish it?  I'm not finding a way to change the format if you use the Power BI service from App.powerbi.com.  If you can alter that data set, I'd love to know how.

[Greg_Deckler]

Desktop. Sorry, you posted in Desktop so I assumed that was what you are using. No, you do not have any control over the data model if you only use the Service to pull in your data. You will have to switch to Desktop.

[Greg_Deckler · Accepted solution]

My blog article might help with this:

http://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

[spencer_g]

This definitely helped anwer my question. Thanks so much!