Forum Discussion

hongpon726's avatar
hongpon726
Copper Contributor
May 25, 2022
Solved

Power query Formular or solution

I'm seeking for a power query formula that the date on the highlighted Colum to be united in US locate, it 's pattern is US locate stay on left hand side, right hand side are convert from text.     ...
BI & Data Analysis
Formulas and Functions
power bi
training
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 25, 2022

    hongpon726 Not quite following. You clearly have a mismatch between your system date settings and the format of the dates your trying to import. From your first screenshot it seems that your system settings use dd/mm/yyyy as the date format, as only dates where the second part exceeds 12 turned into texts. On the other hand, the Shipment Date column is set as a date using  the mm/dd/yyyy format.

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 25, 2022

hongpon726 That's not a formula. change the data type "Using Locale...", the option at the bottom of the list.

Now choose Date and English (United States), and press OK.

 

 

 

Resources