Referencing Intermediate steps from other Power query

Power Query / Get & Transform data in Excel / Power BI - alternative approach to refer ANY intermediate step from one query to other query. Totally dynamic and can refer to different steps in multiple query.
Amazing M Language trick in Power Query.

[@mikehaynes8638]

How is the performance using this method versus creating an extracted version of the referenced query?

[@AbhayGadiya]

I have not tested that yet.

[@mikehaynes8638]

@@AbhayGadiya thanks. This method is great. I’m hoping someday that there’s a trick that caches the source query to only run once and every dependency can use that cache. Would greatly improve performance.

[@tmb8807]

@@mikehaynes8638 Agree. Seems pretty glaring. The only way I've found that forces the data source to be hit only once is to load the 'intermediate' step to a worksheet, and then use the worksheet as the source for any subsequent queries. But that obviously means you end up with a superfluous worksheet (and it won't be of any use if your dataset contains more than 1m rows).