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
Hey there, power BI experts and enthusiasts!
I have been facing quite a problem recently in one of my projects.
The thing is:
I have a column that give me file addresses, with that in mind, i would like to split this column in other columns based on the string "\" delimiting the folders/files/parts of the address.
It must look like something like this:
The column "Adress" is the column I already have, I want to create the others.
If you could help me in this one I'd be really thankful.
Solved! Go to Solution.
In the query editor you can right click on your column and go to split column > be delimeter to break it into multiple fields.
Hi @vyny17 ,
use "Split Column By Delimiter"
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
In the query editor you can right click on your column and go to split column > be delimeter to break it into multiple fields.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!