topic DAX to change datetime format without mins and seconds in DAX Commands and Tips

DAX to change datetime format without mins and seconds

maneschr2022 — Wed, 08 Feb 2023 06:25:14 GMT

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.

Re: DAX to change datetime format without mins and seconds

FreemanZ — Wed, 08 Feb 2023 06:32:18 GMT

hi maneschr2022

try like:

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

it worked like:

Re: DAX to change datetime format without mins and seconds

FreemanZ — Wed, 08 Feb 2023 06:37:37 GMT

you may also change it with some mouse click:

Re: DAX to change datetime format without mins and seconds

maneschr2022 — Wed, 08 Feb 2023 07:03:34 GMT

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?

Re: DAX to change datetime format without mins and seconds

tamerj1 — Wed, 08 Feb 2023 08:06:10 GMT

Hi maneschr2022
You can use

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