Forum Discussion

Joycelu819's avatar
Joycelu819
Regular Visitor
4 years ago

Change time format to Power BI format

Hi guys,

 

I am wondering if I can convert 7pm to 19:00:00 in Power BI.

I have a column of time with same format, which is required to be converted.

 

Thanks

 

Joyce

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Joycelu819 , Assume AM PM are last 2 digits

    if(right([column], 2) = "PM", time(12+left([Column]), len([Column])-2,0,0), time(left([Column]), len([Column])-2,0,0))

    • Joycelu819's avatar
      Joycelu819
      Regular Visitor
      4 years ago

      amitchandak Thanks for your answer. I tried to type this in the query bar, but it did not work. Did I do in a right way?

       

      Joyce

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Joycelu819 ;

    You could select date\time column then change the format to "dd/mm/yy hh:mm:ss". like below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Joycelu819 ;

    Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.