Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Summarize Duration

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!!