Hello,
I'm experiencing some issues with a date column,
I have reviewed some of the suggestions in the forum, but unfortunately, none of the solutions worked.
I'm working with data that was imported from a CSV file (Not sure how important this detail is).
One line is empty in the column
The data type is "text" by default but, when trying to change it to a date, or change it by locale, all become to be "errors"
I tried to:
Nothing seems to be working
Any Ideas to fix it?
Before
After
Solved! Go to Solution.
I changed the source of the data to be XLSX instead of SCV,
It saves a lot of time converting the data
@Rotemshan , Create a new column using Date>FromText([Column])
https://docs.microsoft.com/en-us/powerquery-m/date-fromtext
if required do clean and trim
Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4
I'm sorry - I'm a newbie,
Could you please be more detailed
I tried to google your answer and couldn't understand what steps should be taken
I changed the source of the data to be XLSX instead of SCV,
It saves a lot of time converting the data
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
395 | |
103 | |
68 | |
55 | |
49 |
User | Count |
---|---|
379 | |
117 | |
81 | |
67 | |
53 |