Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
Solved! Go to 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
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
can I change format to 24H without converting to text?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |