Reply
Member
Posts: 66
Registered: ‎12-01-2017
Accepted Solution

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

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"

 

 

Capture24 hhmm.PNGCapture3423.PNG


Accepted Solutions
Community Support Team
Posts: 2,503
Registered: ‎02-06-2018

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

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

1.PNG

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")

2.PNG

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"))

 3.PNG

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

4.PNG 

 

Best Regards,

Jimmy Tao

View solution in original post


All Replies
Community Support Team
Posts: 2,503
Registered: ‎02-06-2018

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

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

1.PNG

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")

2.PNG

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"))

 3.PNG

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

4.PNG 

 

Best Regards,

Jimmy Tao

Highlighted
Member
Posts: 66
Registered: ‎12-01-2017

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

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