Dax time format DD:MM:YYYY HI:MM date time 24 H

[giorgilomidze]

i have date time am pm column and i need to convert it in query editor in date time 24 h format: "DD:MM:YYY HH:MM"

How can i write format?

= Table.TransformColumnTypes(dbo_PrxGetWaterLevelData,{{"DATETIME", type datetimezone}})

or in "advanced editor"

[v-yuta-msft · Accepted solution]

Hi giorgilomidze,

To achieve your requirement, please follow steps below:

1.Make sure that the data type of time column has been changed to Data/Time. In Query Editor, click Transform->Data Type->Select Data/Time

2.Then add a new column in which datatime will be transformed to 24h format. Click Add Column->Custom Column, rename the new column and input M code as below:

Time_New = DateTime.ToText([Time],"dd-MM-yyyy HH:mm:ss")

Or you can also add M code as below in Advanced Editor:

#"Added Custom" = Table.AddColumn(#"Changed Type", "Time_New", each DateTime.ToText([Time],"dd-MM-yyyy HH:mm:ss"))

 

The result is as below and you can refer to PBIX file: https://www.dropbox.com/s/ytnw7d1cpg8fwp7/For%20giorgilomidze.pbix?dl=0

 

Best Regards,

Jimmy Tao

[giorgilomidze]

can I change format to 24H without converting to text?

[dofe2009]

yes you can, have a look at the example below.

TimeMeasure = FORMAT(CALCULATE (

    MIN('Date'[DateTime]),

    FILTER (

        'Date',

        'Date'[DateTime] = whatever

    )

),"HH:mm AM/PM")

its the format that does this, wrap your DAX funtion with a FORMAT and to get the time out of a date.

regards,

Rob.