Forum Discussion

IAM's avatar
IAM
Helper III
4 years ago
Solved

Power Query HH:MM:SS to HH:MM AM

Hi,

 

I have a dataset outside my Power Bi report, so I cannot change it in the column of my report.

 

Is there a way to get a time stamp and change it to text format in HH:MM AM/PM format?

 

In Power Query it is HH:MM:SS AM/PM now, but in my report it shows up as HH:MM:SS

(so without AM/PM)

 

I want to convert it to text in Power Query so it won't change, anyone knows how to use

Time.ToText with reference to a column?

 

  • Hey,

     

    Here's a sample code that illustrates how to use teh Time.ToText.

     

    Time.ToText( #time(12,30,25), "h:MM tt")

2 Replies

  • miguel's avatar
    miguel
    Community Admin

    Hey,

     

    Here's a sample code that illustrates how to use teh Time.ToText.

     

    Time.ToText( #time(12,30,25), "h:MM tt")
  • IAM's avatar
    IAM
    Helper III

    Thank you!

     

    It turned out it was just a glitch, a few hours later it was suddenly correct, but thank you, I will need this later maybe!