Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I need help converting text strings into a date value. My data set has all the date values formatted like "27022024", which is causing an error when I try to use the control to change the data type.
Does anyone know how I can insert a couple / or - so I can get they data type to change?
Any help is greatly appreciated!
Solved! Go to Solution.
In Power Query you can split your column, first split out the left two items so that you have your days, then split out the left two items again so you have month (make sure all three fields (day, month, and year are all text format), then add a custom column named date and insert your field for [MonthField] & "/" & [DayField] & "/" & [YearField]. Then, you can change this to date and remove your other columns.
Proud to be a Super User! | |
In Power Query you can split your column, first split out the left two items so that you have your days, then split out the left two items again so you have month (make sure all three fields (day, month, and year are all text format), then add a custom column named date and insert your field for [MonthField] & "/" & [DayField] & "/" & [YearField]. Then, you can change this to date and remove your other columns.
Proud to be a Super User! | |
User | Count |
---|---|
85 | |
84 | |
71 | |
65 | |
57 |
User | Count |
---|---|
129 | |
102 | |
91 | |
83 | |
67 |