Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity 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
a1b1c1's avatar
a1b1c1
Icon for Advocate I rankAdvocate I
6 years ago

 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?

justlogmein's avatar
justlogmein
Icon for Helper III rankHelper III
4 years ago

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?