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...
DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi maneschr2022 
    You can use

    = TIME ( HOUR ( [TimeMeasure or TimeColumn] ), 0, 0 )
maneschr2022's avatar
maneschr2022
Icon for Helper II rankHelper 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?