DAX's PATH function equivalent Custom Column in Power Query
This custom column formula in Power Query provides an equivalent of DAX's PATH function.
If you have many levels (PATHLENGTH is greater than say 10), it can save you time having to create calculate...
Hello, I know this was posted a while ago, but I would be grateful if someone could help me. How can I extract only the last level of the path, as shown in the figure below? I should only leave the lines in red and get rid of the other lines.
last level means it's a leaf, existing as child but not as parent, easy to verify.