how to conver or format minutes with dax or something else ?

[matheuskei]

i need put the minutes (tempo suprimido) like 00:02 or 0:02 (not like in the firt row 0:2) 

thanks ❤️ 

[ppm1 · Accepted solution]

Please see this article.

Calculate and Format Durations in DAX – Hoosier BI

Pat

[matheuskei]

Hey guys i just wanna say thanks for u support and everything ❤️ u are amazing. 

[tamerj1 · Accepted solution]

Hi @matheuskei 

please try

Tempo Suprimido2 =
VAR String = 'Table'[Tempo Suprimido]
VAR Items =
SUBSTITUTE ( String, ",", "|" )
VAR Hours1 =
PATHITEM ( Items, 1 )
VAR Hours2 =
IF ( LEN ( Hours1 ) = 1, "0" & Hours1, Hours1 )
VAR Minutes1 =
PATHITEM ( Items, 2 )
VAR Minutes2 =
IF ( LEN ( Minutes1 ) = 1, "0" & Minutes1, Minutes1 )
RETURN
TIMEVALUE ( Hours2 & ":" & Minutes2 )

[ppm1 · Accepted solution]

Please see this article.

Calculate and Format Durations in DAX – Hoosier BI

Pat

[nchr]

What is the data type of the measure that gives you the time? Is it DATETIME, is it seconds, minutes, fraction of the day?

If the tempoSuprimido measure is text, then maybe you can use this:

FORMAT( TIMEVALUE([TempoSuprimido]), "nn:ss")

[tamerj1]

Hi @matheuskei 

try by using TIMEVALUE function