Forum Discussion
Numbers convert into duration
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.
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.