Forum Discussion

ZMadarasi's avatar
ZMadarasi
New Member
1 year ago
Solved

Convert Stuctured Text to DateTime

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
Tips and Tricks
  • miTutorials's avatar
    miTutorials
    1 year ago

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

     

     

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

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.