Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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! | |