POWER QUERY EXCEL ADD ON HOW TO

Since you’ll now have 2 columns as your filter criteria (region and sales rep).Well if you did understand the previous one, this is just going to be a cakewalkĮverything remains the same except one thing It would not be so uncommon to come across the need to filter data with multiple columns with multiple filter conditions. #3 – Filter Data with Multiple Filter Conditions from a Multiple Columns Done! And yeah…the extra column that gets created, please remove that.At the bottom the Join Kind will be Inner (which means only matching rows will be picked up).Select the 2nd query as Filter (with 2 rows i.e.In your Data Query go the Home Tab > Merge Queries.Let’s load both the tables again (with Region filters having 2 values instead of 1) and let’s try this instead. Remember drilling down on the first row? And because we did that the query will always have a single value for the first row, even if the user inputs 2 values. Can we? Sure we can, but in this case I would slightly change the approach and before I explain it, I’ll share why the earlier approach won’t work! Someone would definitely argue the flexibility to filter Region by multiple values. #2 – Filter Data with Multiple Filter Conditions from a Single Column Now each time the user changes the Region, I’ll have the updated data.I then apply a pseudo filter “East” and then replace that with the “Filter” query in the formula bar.Drilling down enables me to return a query with a single value (even if the user specified 2 values).I am going to right click on the value “West” in the Filter Query and Drill Down.

POWER QUERY EXCEL ADD ON HOW TO

Let’s say you would like to filter the Region Column in your data by the value the user inputs in a cellĪssuming that you know how to load the Data (both tables) in Power Query, let’s see what comes next. #1 – Filter Data with a Single Filter Criteria Although you have the ability to apply filters (just like Excel) in Power Query but in this post I am going to share that how can you apply dynamic filters (filter criteria that can change) using Power QueryĪnd to make this a little more spicy, I’ll delve into a 3 scenarios to explain the problem in different contexts Recently while on a consulting assignment, I had the need to dynamically extract data based on filters given by the user.

Power query excel add on