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

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