Convert Stuctured Text to DateTime

[ZMadarasi]

Hello,

Do you have experience

  with Text Columns like "250605_063623" where "YYmmdd_HHMMSS" to

  make it Datetime Column "2025.06.05. 6:36:23"?

BR,

Thanks,

Zoltán

[v-pnaroju-msft]

Thankyou, @miTutorials, for your response.

Hi ZMadarasi,

We appreciate your inquiry posted on the Microsoft Fabric Community Forum.

Please find attached the screenshot and the PBIX file, which may assist in resolving the issue:

If our response proves helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will benefit other community members who may have similar queries.

Should you have any further questions, please feel free to reach out to the Microsoft Fabric Community.

Thank you.

[miTutorials · Accepted solution]

 Add Custom Column in the Power Query Editor and use the below code..

= DateTime.FromText(
       Text.Middle([YourColumn],  4,  2)  & "/"  &  
       Text.Middle([YourColumn],  2, 2)  &  "/"  & 
       "20"  &  Text.Start([YourColumn],  2) &  "  "  & 
       Text.Middle([YourColumn],  7,  2)  & ":"  &  
       Text.Middle([YourColumn],  9, 2)  &  ":"  & 
       Text.End([YourColumn],  2)
)