Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HELP! I have the next values :
When i open Power Query I set the data as duration and I can see the seconds and minutes, BUT when i close and apply this is the data I get 😞 I have tried the many solutions I found here but none has worked, I have no idea what to do next please help.
PS: I tried this code but I get error
Solved! Go to Solution.
Hi, @Amanda_Mendez
There is not much problem with your formula.
Column:
You also need to convert the text format to a time format. You can use the function TIMEVALUE.
TIMEVALUE function (DAX) - DAX | Microsoft Learn
Conversacion real time =
VAR _Seconds = [Time]
VAR _Minutes = INT ( DIVIDE ( _Seconds, 60 ) )
VAR _RemainingSeconds = MOD ( _Seconds, 60 )
VAR _RemainingMinutes = MOD ( _Minutes, 60 )
RETURN
TIMEVALUE(IF (
NOT ISBLANK ( _Seconds ),
FORMAT ( quotient(_Seconds,60), "00" ) & ":" & FORMAT ( mod(_Seconds,60), "00" )))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Amanda_Mendez
There is not much problem with your formula.
Column:
You also need to convert the text format to a time format. You can use the function TIMEVALUE.
TIMEVALUE function (DAX) - DAX | Microsoft Learn
Conversacion real time =
VAR _Seconds = [Time]
VAR _Minutes = INT ( DIVIDE ( _Seconds, 60 ) )
VAR _RemainingSeconds = MOD ( _Seconds, 60 )
VAR _RemainingMinutes = MOD ( _Minutes, 60 )
RETURN
TIMEVALUE(IF (
NOT ISBLANK ( _Seconds ),
FORMAT ( quotient(_Seconds,60), "00" ) & ":" & FORMAT ( mod(_Seconds,60), "00" )))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Pls help again. I get this data, is there a way to also show seconds? for example 17.39 = 00:17:23, thank you in advance 🙂
YES! thank you so much, it is now in hh:mm:ss format. 🎊
@Amanda_Mendez , Change data type time and try
Or create a new column in dax
time(0,0,0) + [Column in hours]/24
or
time(0,0,0) + [Column in Minute]/(24*60)
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |