Forum Discussion

PowerBINoob24's avatar
PowerBINoob24
Resolver I
1 year ago
Solved

Transforming text to date

This is probably staring me right in the face, but I can seem to get the conversion to work.  I've loaded data from an excel file.  The columns with Date and Time data read, for example, 2025-06-20 1...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi PowerBINoob24 

    Right click a cell then click Replace Value. Replace UTC with nothing.

    Change the type to datetime. If you need just the date, change it to type date after changing to datetime. Power Query will return an error if you change it to date directly.

     

     

danextian's avatar
danextian
Super User
1 year ago

Hi PowerBINoob24 

Right click a cell then click Replace Value. Replace UTC with nothing.

Change the type to datetime. If you need just the date, change it to type date after changing to datetime. Power Query will return an error if you change it to date directly.

 

 

v-dineshya's avatar
v-dineshya
Community Support
1 year ago

Hi PowerBINoob24 ,

Thank you for reaching out to the Microsoft Community Forum.

 

This issue is common when working with datetime strings that include time zone indicators like "UTC". Power BI reads such strings as text, and the "UTC" suffix can prevent automatic conversion to a proper datetime format.

 

Please follow below steps to fix the issue.

 

1. Created table "Table" with sample data. please refer below snap.

 

 

2.  In Power Query editor, Add column --> Custom column ,  and use below code. refer below snap.

 

 

3.  Custom column "Custom" was created and then select the custom column and change the data type to "Date/Time". refer the snap.

 

 

4. converted the custom column from "text" to "Date/Time" format. Please refer the output snap and attached PBIX file.

 

 

I hope this information helps. Please do let us know if you have any further queries.

 

Regards,

Dinesh