Replicate DAX function in Power Query M

[AGo]

Is there a way of replicate dax function PATH() , also PATHLENGTH() if possible, in Power Query M, in the query editor?

Thank you

[v-caliao-msft]

@AGo,

There is no such a function in Power Query. What we can do is create a custom function in it, and achieve similar feature in Power Query, please refer to the link below to see the details.
https://bondarenkoivan.wordpress.com/2016/09/09/unfold-child-parent-hierarchy-in-power-query/

Regards,

Charlie Liao

[AGo]

This solution goes in stack overflow for me.