Duration format

[JonathanJohns]

Good afternoon,

I was using a database in Power BI with some durations but I had a problem. The format is a time format like this one : HH:MM:SS and not a duration. And I would like to get a format which permits me to do different calculations as average.

Here is the example : 00:12:00 (time format) and I would like to get 12,00. When I change the format and I choose Duration, it shows me an error. 

Do you know how to make this transformation without created a new column please ?

[v-shex-msft · Accepted solution]

HI @JonathanJohns,

Power bi not support duration type, I'd like to suggest you convert it as total second or other similar numeric value to calculate.
You can also take a look at below blog to know how to handle with duration in power bi:

Aggregating Duration/Time

Regards,

Xiaoxin Sheng