AVG SSession Time Format

[Anonymous]

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?

[Greg_Deckler · Accepted solution]

@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