Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |