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'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
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 |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |