Get Hour (with AM/PM) from DateTime field

[Anonymous]

I have a timestamp field that I would like to pull the hour with AM and PM.  I have HOUR('Call Logging'[CALL_DATE]) but it displays millitary time.  Any help is appreciated.

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

Do you want to extract Hour at each time and add AM/PM later?

If I understand correctly, please refer the followng measure,

Measure = 
HOUR(MAX(Dates[Cdate])) &" "& RIGHT(MAX(Dates[Cdate]),2)

If it doesn't meet your requirement, could you please show the exact expected result?

It will be helpful if you can show us the desire result based on fake data.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Not sure I got it. As long as any datetime is detected as date type you can change its format to the desired format using the format option

[mahoneypat]

Instead of HOUR() you can use FORMAT('Call Logging'[CALL_DATE], "h AM/PM")

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

I'm using DQ as my data source.