Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Is there a way of replicate dax function PATH() , also PATHLENGTH() if possible, in Power Query M, in the query editor?
Thank you
@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
This solution goes in stack overflow for me.
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
