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.
hello, i have a folder with .txt files, as usual i do from data then from folder
so both text files are combined, in text file i have dates which are imported as text data type, when in power query i try to change data type to Date type, some are changed others are giving error, cant figure out what is the issue
Solved! Go to Solution.
The screenshot of your regional settings shows that your date format is d/m/y.
This screenshot shows that the data you are importing is in m/d/y format
To import these dates correctly what you need to do is Change the date using Locale.
Right-click on the column header and then on Change Type -> Using Locale
Then choose Data Type -> Date and Locale -> English (United States)
Click OK and you should be done.
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Thanks, local was useful 👍
The screenshot of your regional settings shows that your date format is d/m/y.
This screenshot shows that the data you are importing is in m/d/y format
To import these dates correctly what you need to do is Change the date using Locale.
Right-click on the column header and then on Change Type -> Using Locale
Then choose Data Type -> Date and Locale -> English (United States)
Click OK and you should be done.
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Hi this is the error message
Also some sample data which is a .txt file , so the date when its imported to power query and i press in the column to change type to date, some dates are changed while others show error
Date Sales Product
1/2/18 3 Carlota
1/5/18 2 Carlota
1/7/18 25 Carlota
@chahineatallah , what is your system date setting , 1/15 is fine. Is System date setting is UK /AUS/IND format ?
@chahineatallah , Click on the error and share that. Also share some sample data
nope its month day and year
@chahineatallah , Are you dates is in DD/MM/YYYY format. If so you need to have following setting
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 |
---|---|
108 | |
95 | |
75 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
66 |