Forum Discussion
Numbers convert into duration
I am using Duration = FORMAT(Test[Duration_avg]/60, "hh:MM:SS"), will test if it works well.
My prediction is that you will get the time that corresponds with the fraction of your division:
You reallly need to go back and find out what your value represents, otherwise you are bound to create the most beautiful dashboards with highly unreliable information and you'll be in big trouble sooner or later.
MarcelBeug you are right. i know couples of way to get "hh:mm:ss". I need to go back to understand the data better first, and make sure to come up the reliable numbers.
Look at my first post on page 2: #duration(0,0,0,4356)
Unlike #date, #datetime and #datetimezone,
#duration allows individual elements (days, hours, minutes, seconds) to exceed the natural limits like <24 and <60.
You can even have a mix of positive and negative arguments, e.g. #duration(0,0,2,-90) gives 0.00:00:30 (2 minutes minus 90 seconds).
Thanks all, I have the right numbers by using the DAX in this post
https://community.powerbi.com/t5/Developer/formatting-time-value-to-hh-mm-ss/td-p/85249
And next question :
How to get the average of duration
For example :
0.0275 0:42:34 1:05:30 1:10:16 I want to get the average duration of above 4 durations in the table.