Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
6 years ago

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...
Other
toum's avatar
toum
Icon for Helper II rankHelper II
3 years ago

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.

  • RealSir's avatar
    RealSir
    Frequent Visitor
    1 year ago

    last level means it's a leaf, existing as child but not as parent, easy to verify.