Zubair_Muhammad's avatar
Zubair_Muhammad
Community 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
mloyalka1996's avatar
mloyalka1996
Frequent Visitor
3 years ago

Hi Scott, Thank you for the code. I have a couple of question regarding the funvtion you have written. A small question what does it mean when u say "A topmost record should have a null in the Parent field". do i need to add a record ?

Scott_Parker's avatar
Scott_Parker
Frequent Visitor
3 years ago

I rephrased it. I meant a record at the top of the hierarchy, meaning it has no parents, should have Parent = null, rather than Parent = Self because it would result in infinite recursion.

  • mloyalka1996's avatar
    mloyalka1996
    Frequent Visitor
    3 years ago

    thanks for that Scott. I created a coloumn called task_final. so whenevr Parent=self i replaced the value of child to null or kept the child value. Now when i am running the function with the following parameters. I still get an error. Any suggestion?

     

    • Scott_Parker's avatar
      Scott_Parker
      Frequent Visitor
      3 years ago

      I have added clarification. Invoke the function on the table in one go, not for each row.

      • mloyalka1996's avatar
        mloyalka1996
        Frequent Visitor
        3 years ago

        thank you scott for the clarification. I am bit new to power bi . I am trying to run function as a whole but I am not able to . It will be a big help if you can provide some help on how I can run the function as a whole