Forum Discussion
Solved
Convert Date_Time format to DDMMYYYYHHMMSS numeric format.
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 ...
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"])
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"])
- Thanks a lot! the concern has been solved.
