Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Time converting

 

 

 

Helloo, 

 

I'm beginner to PowerBi, I have this type format on Excel ( [h]:mm:ss) I would like to know how to have the same format?

 

thks 🙂

 

 

 

 

 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Change the data type to Time. You should be able to that in Column tools in data view

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I've done this before and didn't get the result I'm looking for. I used this code to convert to Datetime but the result is not good

       

       

      • amitchandak's avatar
        amitchandak
        Super User
        4 years ago

        Anonymous , if the first column is datetime, then this should work. It is case sensitive 

        DateTime.ToText([Column1], "HH:mm:ss")

        .