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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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