Forum Discussion

maneschr2022's avatar
maneschr2022
Icon for Helper II rankHelper 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...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi maneschr2022 
    You can use

    = TIME ( HOUR ( [TimeMeasure or TimeColumn] ), 0, 0 )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

you may also change it with some mouse click: