topic how to conver or format minutes with dax or something else ? in DAX Commands and Tips

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

matheuskei — Fri, 10 Feb 2023 19:11:24 GMT

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

thanks ❤️

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

tamerj1 — Fri, 10 Feb 2023 20:19:15 GMT

Hi matheuskei

try by using TIMEVALUE function

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

nchr — Sat, 11 Feb 2023 18:44:47 GMT

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")

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

ppm1 — Sun, 12 Feb 2023 14:23:41 GMT

Please see this article.

Calculate and Format Durations in DAX – Hoosier BI

Pat

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

tamerj1 — Sun, 12 Feb 2023 15:26:49 GMT

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 )

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

matheuskei — Thu, 23 Feb 2023 13:36:08 GMT

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