Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I started with a column of data that looked like this Grocery\2023\q1\01-15-2023-01-20-203-Supermarket1
I used transform data to break it into columns and I got it down to this column
01-15-2023-01-20-203-Supermarket1.
But I want to split 01-15-2023-01-20-203-Supermarket1. into 01-15-2023-01-20-203 in one column and Supermarket1 into another column. Ideas on this?
Split Column by delimiter ('-' once, as far right as possible)
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.