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...
Hi Zubair_Muhammad, Daniil
Either of the steps are too time consuming, it's been running for about 45 minutes and still hasn't been able to complete this step. Any help?
I have tried this method and you are correct, this is much too inefficient. I have only 6,000 rows and we are talking hours to run. Did you find another solution?