Sum of time is not showing correctly

[gauravnarchal]

Hello

How can I convert the column to time in hh:mm:ss format using DAX? I am trying to change the format but it is not working.

Call Duration (hh:mm:ss)

00:06:10

00:01:13

00:00:37

00:02:20

00:01:18

00:00:21

00:00:04

[v-xiaotang · Accepted solution]

Hi @gauravnarchal 

Please refer to my solution in this post, Re: Is there Excel time format 37:30:55 in Power B... - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[mangaus1111]

Hi @gauravnarchal ,

see my pbi file. I hope it can help you.

https://1drv.ms/u/s!Aj45jbu0mDVJi2n5BfCXzJx458iO?e=xbxYez

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JorgePinho]

Hello @gauravnarchal !

See if this helps: https://community.powerbi.com/t5/Developer/formatting-time-value-to-hh-mm-ss/m-p/85249

[gauravnarchal]

Hi, @JorgePinho  I have tried but still, my total is not showing correctly.