How to display timestamp with AM and PM

[Anonymous]

Hello guys,

I have a calculated column named GetTime and its calculated the current timestamp. See the image below. I would like to display the value of this column in a chart and the output must be like 16:50 AM or 8:40 PM.  At this moment i only get 16:50 as value in a chart. 

Any suggestions?

[Daniil · Accepted solution]

I'm not exactly sure about "16:50 AM" (shouldn't it be 4:50 AM?), but there are at least two ways to accomplish your goal:

1. Change formatting of the column
   
2. Explicitly format the column as a text string:
   

   Gettime = FORMAT ( NOW(), "h:mm am/pm" )

If you are using a card visual, the end result is almost the same. The second approach allows you to define capitalization (am/pm or AM/PM).

[mateoc15]

This is extremely helpful.  It's odd that DAX and the column version are different sets of formatting, for me it was specifically the "tt" for AM/PM in one and just plain "AM/PM" in the other.  In any event, it worked.  Thank you.