Forum Discussion

OmarSaleh's avatar
OmarSaleh
Helper I
5 years ago
Solved

Problem in changing format from text to date

Hi,    One of the tables I have is imported from an excel sheet with a column in Date/Time format as shown below.      I need to convert it to Date in power Bi (not excel). The step I'm fo...
Need Help
Show and Tell
  • HotChilli's avatar
    HotChilli
    5 years ago

    right-click on the column, pick 'change type'-> using locale.  I can't remember if you need to pick English(uk) or English(u.s.) but one of them will work

KNP's avatar
KNP
Super User
5 years ago

Hi OmarSaleh - try conversion using locale.

 

 

 

= Table.TransformColumnTypes(Source, {{"Column1", type text}}, "en-NZ")
OmarSaleh's avatar
OmarSaleh
Helper I
5 years ago

Just found it by right clicking on the column --> change type instead of using the tools bar. Thank you KNP!