Forum Discussion

IAM's avatar
IAM
Icon for Helper III rankHelper 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?   I...
Need Help
  • miguel's avatar
    miguel
    4 years ago

    Hey,

     

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

     

    Time.ToText( #time(12,30,25), "h:MM tt")
miguel's avatar
miguel
Icon for Community Admin rankCommunity Admin
4 years ago

Hey,

 

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

 

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