Forum Discussion
Solved
Recursively split string into columns
I want to create some sort of "tree map visual" from some data stored in a DB, let me explain a little bit. I have the following sample data: MainPage MainPage/Page1 MainPage/Page1/SubPage Mai...
ebecerra You can do a split and then Unpivot other rows in Power Query or you can use SUBSTITUE(MAX('Table'[Column]), "/", "|"). That will turn it into a path and you can use the PATH functions like PATHLENGTH.
Thanks Greg_Deckler that seemed to do the trick to get me going.