Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Duration to time

Hi Community,  I have a column with a duration in sec. I need to transform this into time HH:MM:SS First, I did 3 new columns: -Hour = ROUNDDOWN(table[duration]/3600,0)  -Minute = ROUNDDOWN((tab...
natabird3's avatar
natabird3
Icon for Skilled Sharer rankSkilled Sharer
7 years ago

To be honest i do not think you will be able to make it work in Power Bi to dispaly this way. I have tried many options, and unfortunately currently is not supported as far as i am aware. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I think you are right.

    I tried another 2 totally different ways, that logically should work, and get the same (mistaken) result.