From the course: Excel Power Query Tips and Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Reference a query

Reference a query

From the course: Excel Power Query Tips and Techniques

Start my 1-month free trial

Reference a query

“

- [Narrator] In Power Query, we can reference a query, and it is a very handy thing, but it can be kind of difficult to understand. So I've got a couple of diagrams to show a couple of reasons why we might reference a query. So let's look at this first one. Now let's say we've got our source data that would go through steps one through four, and then that gets us a result that we want. But we would like to start at that point, and then do some more with the data. But if we do it all in one big query, we won't have desired result one, we would just have desired result two at the end. So we do query a up to a certain point, get that result, reference the query, and keep going. Another reason, and that's what we're going to see in this example, we've got query a, but we need two end results. But we start off, steps one through four are the same for both. So we'll do those first four, reference the query, then do the three…

Contents