Forum Discussion
Numbers convert into duration
Haha I understand it is a number. What I'm asking is what is that number? Days? Seconds? In order to properly calculate duration we can do some simple math to transform it but if you don't know what the granularity is then you have bigger problems than the duration being inaccurate.
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.
