Forum Discussion

Icon for Helper II rank

Helper II

3 years ago

Solved

DAX to change datetime format without mins and seconds

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
3 years ago
Hi maneschr2022
You can use

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

4 Replies

tamerj1
Community Champion
3 years ago
Hi maneschr2022
You can use

= TIME ( HOUR ( [TimeMeasure or TimeColumn] ), 0, 0 )
FreemanZ
Super User
3 years ago
hi maneschr2022
try like:
Column = FORMAT([datetime], "m/d/yyyy hh.mm AM/PM")
it worked like:
FreemanZ
Super User
3 years ago
you may also change it with some mouse click:
maneschr2022
Helper II
3 years ago
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?