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!
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! | |
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
