Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i need put the minutes (tempo suprimido) like 00:02 or 0:02 (not like in the firt row 0:2)
thanks ❤️
Solved! Go to 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 )
Hey guys i just wanna say thanks for u support and everything ❤️ u are amazing.
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 )
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")
User | Count |
---|---|
57 | |
21 | |
19 | |
16 | |
16 |
User | Count |
---|---|
86 | |
77 | |
52 | |
37 | |
22 |