Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
My original data is text format and month and date are otherway around due to wrong regional setting.
It is supposed to be 1 Jun 2019 but shown as 6 Jan 2019 when I change format by using data type.
I want to marge two tables later so I want to amend it by using custom column fomula in query.
The folllowing dax works in data but not query. Can anyone help?
=DATE(YEAR([Date]),DAY([Date]),MONTH([Date]))
All the best,
LoveParis
Solved! Go to Solution.
Try creating a custom column in Power query with the code:
Date.FromText([Column1], "en-US")
and then change the type of the new column to Date. If required, delete the original "Column 1"
Hi @paris
Have you tried changing the file option for loading data and choosing the locale you need? Go to
Options and Settings->Options-> (Current File) Regional settings
and in "Locale for import" choose an appropriate option. English(United States) would probably do it, from what you describe. The selection of the locale need to happen before you change the type of the column to Date
Try creating a new column using "Columns from Example". Try the below steps:
🙂
Try creating a custom column in Power query with the code:
Date.FromText([Column1], "en-US")
and then change the type of the new column to Date. If required, delete the original "Column 1"
Hi AIB,
Thank you very much for your advice. It worked perfectly.
All the best,
LoveParis
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |