DAX to change datetime format without mins and seconds

[maneschr2022]

Hi I would like to use a dax to change the datetime format from ex: 11/03/2023 11.36.27AM to 11/03/2023 11.00 AM.

I just would like to convert the datetime values to show dates and hours but not the mins and seconds associated to it.

[tamerj1 · Accepted solution]

Hi @maneschr2022 
You can use

= TIME ( HOUR ( [TimeMeasure or TimeColumn] ), 0, 0 )

[maneschr2022]

@FreemanZ Hi, I want to be able to transform the mins to show them as 00, instead of value, example if time is 11.38AM I want to show it as 11.00AM, if that make sense?

[FreemanZ]

you may also change it with some mouse click:

[FreemanZ]

hi @maneschr2022 

try like:

Column = FORMAT([datetime], "m/d/yyyy hh.mm AM/PM")

it worked like: