While Power Query can combine queries, append queries or merge queries, sometimes we may want to take the result of a query and further extend it in another scenario, or combine the results of 2 queries into a third query. In this case, the Reference option of Power Query (in Excel & in Power BI) can be be used easily.
