Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
In the query editor you can right click on your column and go to split column > be delimeter to break it into multiple fields.
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
54 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |