From the course: Excel Power Query Tips and Techniques

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Pass parameter: Drill down to a single value

Pass parameter: Drill down to a single value

From the course: Excel Power Query Tips and Techniques

Start my 1-month free trial Buy for my team

Pass parameter: Drill down to a single value

“

- [Instructor] Here is our source data with vendors, aquarium types, phone numbers, et cetera and over here is the result of a query. And in cell B2, we have a number. We would like to pick that number and that 100 would mean show me the vendors who have not purchased from us in 100 days or more. And we would like to change that number, 50, 1000, whatever. How can we pass that 100 into Power Query and have it updateable, all right? This is what we're going to call pass a parameter or drill down. You ready? Okay. We've got data, okay, queries and connections. We already have the source data in this query called customers. Now we need the 100 in a query. Here we go, click inside that data range from table slash range, okay. So here is the number we want, and let's name this query, let's call it last sale. Last sale, all right. That's the name of the query. Now what we have to do is right click on this value…

Contents