Convert hour as 12:00 AM (hour with AM/PM)

[JustinDoh1]

I am sharing my Pbix file here.

I am trying to convert from datetime like

2/23/2020 10:08:00 AM  to  10:00 AM.

The reason is that I am trying to create visual like this:

I have a column called "IncidentDate".

I was able to convert the DateTime to Hour like this:

But, what I am trying to get as a final product is like:

10:00 AM

8:00 AM

3:00 PM

How do I go about doing this?

Thanks.

[Greg_Deckler · Accepted solution]

@JustinDoh1 Well, one way would be to create a new column like this:

Column = IF([Hour]<=12,[Hour] & ":00 AM", ([Hour]-12) & ":00 PM")

[JustinDoh1]

@Greg_Deckler  Thank you Greg again!