Forum Discussion
duration not working correctly
hi, im running a powershell script which takes duration for a backup.
I can see the result as "00:26:43" in powershell.. but as whole numbers when inserted in the database/powerbi data.
How can I convert these numbers, so it looks like the powershell script.
I want the same result as in the powershell script.. so I can see the backup too "00:26:43" Minuttes.
please help
btw : i tried with some custom columns on the right, where I divided by 60.. but it didnt end up quite right. 😕
thanks all
4 Replies
aso1 ,refer
https://docs.microsoft.com/en-us/powerquery-m/duration-functions
refer
https://community.powerbi.com/t5/Desktop/Numbers-convert-into-duration/td-p/189081
if they in second , in DAX
time(0,0,[column])
or refer
Hi aso1 ,
Try to change the data type.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi aso1 ,
Has your problem been solved?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
