Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
YcnanPowerBI
Helper II
Helper II

Changing format to time of hh:mm:ss v hh:m:s

Hello - I have the below DAX to sum up a talk time column, but I would like to is to display in hh:mm:ss.  The screenshot below shows how it shows up on my report where it may show 1 or 2 digits for minutes or seconds depending on total.  Any way to change this to hh:mm:ss?  Thanks in advance for any help here!

 

 

1 Inbound Total Talk Time = var _sum = sum(Append1[Inbound Talk Time])
VAR hours =  INT( _sum * 24 )
VAR Minutes = MINUTE(_sum)
VAR Seconds = SECOND(_sum)
RETURN
Hours & ":" & Minutes & ":" & Seconds
 
Nresendes_0-1709571700033.png

 

1 ACCEPTED SOLUTION
YcnanPowerBI
Helper II
Helper II

I found the solution!  Changed the last segment to 

FORMAT(Hours, "00") & ":" & FORMAT(Minutes, "00") & ":" & FORMAT(Seconds, "00")

View solution in original post

1 REPLY 1
YcnanPowerBI
Helper II
Helper II

I found the solution!  Changed the last segment to 

FORMAT(Hours, "00") & ":" & FORMAT(Minutes, "00") & ":" & FORMAT(Seconds, "00")

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.