Forum Discussion

rjs2's avatar
rjs2
Resolver I
5 years ago
Solved

Duration M Query and Data tab

Hi,   I am having an issue with duration.  In M Query everything looks right and I have it set as duration 0.00:00:00, but once it comes into PBI I get nothing but Zeros.  When I hit the drop down ...
Show and Tell
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

rjs2 Just to add to az38 , what I believe you are seeing is fractions of a day. So 2 hours for example is 1/24 * 2. Minutes are 1/24/60 and seconds are 1/24/60/60. 

 

You may want to review this article as I am assuming that you will want to display them as distances at some point

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

 

And this one may be useful as well:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92