AVG SSession Time Format

Anonymous — Tue, 26 Jan 2021 09:05:37 GMT

Hi,
I calculate average time in this way:

AVG_Session_Time = AVERAGEX( SUMMARIZE( Full_Table_Events, Full_Table_Events[ga_session_id] , "_1", MIN('Full_Table_Events'[event_timestamp]) , "_2", MAX('Full_Table_Events'[event_timestamp]) ), DATEDIFF([_1],[_2],MINUTE) )

The result looks like this:

But is not 7 minutes and 84 seconds. This 7 minutes and 84% from the minute. So it must be 00:07:50.

Is it possible to get a result in such a format?

Re: AVG SSession Time Format

Greg_Deckler — Tue, 26 Jan 2021 09:19:50 GMT

Anonymous Seems like you would need to convert this to the total number of seconds like:

Column = INT([Column1]) * 60 + (([Column1] - INT([Column1])) * 60)

That's just an example. You could then apply the formatting technique per something like Chelsie Eiden's Duration: https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

topic AVG SSession Time Format in DAX Commands and Tips

AVG SSession Time Format

Re: AVG SSession Time Format