Convert Date_Time format to DDMMYYYYHHMMSS numeric format.

[Om2023]

Hello Everyone,

Can someone help with the below problem?

I want to convert the Date_Time column into the "DDMMYYYYHHMMSS" numeric format using Power BI Query Editor only.

DATE_TIME	Resulted column
01-Jan-24 10:17:41 PM	1012024221741
01-Jan-24 10:22:34 PM	1012024222234
01-Jan-24 10:25:12 PM	1012024222512
01-Jan-24 10:28:30 PM	1012024222830
01-Jan-24 10:30:56 PM	1012024223056
01-Jan-24 10:33:41 PM	1012024223341

Thanks in Advance!

[ZhangKun · Accepted solution]

add a custom column and use following code.

DateTime.ToText(DateTime.From([DATE_TIME], "en-us"), [Format = "ddMMyyyyHHmmss"])

If you are using an English system, you can remove "en-us". For example, the following code.

DateTime.ToText(DateTime.From([DATE_TIME]), [Format = "ddMMyyyyHHmmss"])

[Om2023]

Thanks a lot! the concern has been solved.