Forum Discussion
Using table as a feed for a new query
Yeah, this workss nicely. Good thinking.
the why is that my ragged hirarchy has a top level of 2500+ with a near exponential rate through 12 generations but still growing. I tried using a power query function but it cycled through one record at a time. I tried using DAX to do a calculated table of what i wanted to do but the calulation time was although much faster, still too slow. Using power query to split and unpivot DAX results based on =PATH & =PATHITEM is about 22 time faster than the calculated table method and literally 100's of time faster than the custom function method.
Yeah, this workss nicely. Good thinking.
the why is that my ragged hirarchy has a top level of 2500+ with a near exponential rate through 12 generations but still growing. I tried using a power query function but it cycled through one record at a time. I tried using DAX to do a calculated table of what i wanted to do but the calulation time was although much faster, still too slow. Using power query to split and unpivot DAX results based on =PATH & =PATHITEM is about 22 time faster than the calculated table method and literally 100's of time faster than the custom function method.
Hi samdthompson ,
Thanks for your additional clarification, indeed, there are pros and cons to dax and power query.
Could you pls mark your reply as answered to let more people find the solution?
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
