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 friends,
I'm trying to convert a text column to date format to sort the visualizations in chronological order, but I'm getting errors in Power Query. I tried with different date formats (Jan -> January), but I keep getting the same error.
Any help?
Solved! Go to Solution.
try to add "-1" after month, then you can convert.
[Column1]&"-1"
Proud to be a Super User!
try to add "-1" after month, then you can convert.
[Column1]&"-1"
Proud to be a Super User!
Thanks, it did work, but just out of curiosity, can you explain why?
I learned this from other experts on this community. 😄
Proud to be a Super User!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |