Forum Discussion

jingwen's avatar
jingwen
New Member
3 years ago

Duration

Hi,

 

I need to convert the duration to hh:mm. The format in excel is already [h]:mm. I cannot use datediff because the values for verified downtime will be from different columns. Can someone please help me. 

 

Thanks. 

 

Need Help

1 Reply

  • olgad's avatar
    olgad
    Resident Rockstar
    3 years ago

    Hey, if the fiormat is already in h:mm how does it get picked up by power bi initially? go to the first change type under the applied steps, see what is the datatype for that column there, click on duration data type being on the step, add new step then replace the current step and see if it helps.