Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Milliseconds Duration

Based on the original blog post around Duration from 1/25/16 by konstantinos and later blogged about here: https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486   ...
Time Intelligence
davorgom's avatar
davorgom
Frequent Visitor
8 years ago

HI Greg_Deckler

 

Thanks to your help. Your comments are very helpful.

 

I wanna say you that the idea is getting well, but I have problems with milliseconds to minuts. I don´t know if Im wrong.  As you can see at the files attached, in a 100m race, a runner made 12.40 sgs, and it appears 12:400, its ok. But when the result is in minutes, for example a 1500m race, where the runner has 33:29.71, power bi shows 5:32:971.  The graphs appears wrong too. There is a possibiity to improve this?

 

On another hand, when I try to graph the places of the 100m record,  it shows 12.4mil. There is a possibility to eliminate the text "mil"? Change it for min?

 

Thanks for your time. Its really important that there is persons who wanna teach anothers to use this app.

 

Best regards. 

 

David