Summarize Duration

[Anonymous]

Hi team, how are you?

I'm having a problem here to summarize a duration column that has that format: 01:24:22

I had a different format initially, but I converted it to seconds, then I converted it to that format above with this code here: https://gist.github.com/jongio/5b8dcf13ab957cecfec3932a42db0e58

The problem is, that field is considered a text field, therefore I can't summarize it anyhow. I need help to be able to summarize this data, I don't know if it is possible to apply this conversion code after the agregation in seconds. I tried to convert it to the type Time and with this format but it also did not worked.

I'm new to PBI so if the solution is complex, I would be glad if there was an explanation of it.

Thank you all for the support already!!

[Greg_Deckler · Accepted solution]

@Anonymous 
Duration
Look at the links below, they should get you what you need.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92