Alessandro Goretti on 18 Nov 2021 12:44:02
Path function can only manage hierarchies with a single parent ID for each ID value, this is not possibile when trying to calculate the path for eg. bill of materials.
It would be very smart to implement a wizard button for the Power Query editor too, just to flatten a multi-parent hierarchy near the pivot and un-pivot functions.
What I found on the web for this case it's back from the 2017 and no improvement on this side have been done! https://www.thebiccountant.com/2017/02/14/dynamically-flatten-parent-child-hierarchies-in-dax-and-powerbi/