Filter Based on Cell Values in Power Query | DYNAMIC Power Query Filters

In this video, we learn how to filter based on cell values in Power Query. In the video, we'll show you how to filter data in Power Query using cell values as criteria.

If you've been struggling with filtering large datasets in Power Query, you'll find this tutorial extremely helpful. We'll walk you through the steps required to apply filters based on cell values.

You'll be able to quickly and efficiently filter data in Power Query, making it a powerful tool for data analysis and reporting. These dynamic filters can be refreshed when a cell value is changed.

Whether you're a beginner or an experienced user of Power Query, this tutorial is perfect for anyone looking to improve their data analysis skills. So, if you want to learn how to filter based on cell values in Power Query, be sure to watch this video and subscribe to our channel for more helpful tutorials.

00:00 - Filter based on cell values in Power Query
01:24 - Filter table of data in Power Query
06:15 - Dynamic file selection by cell value
10:42 - Refreshing the power queries

*** Online Excel Courses ***

Connect with us!

#powerquery #powerquerytutorial #msexcel

[jeezzrom]

Since months I have been looking for something like this! Very useful! Thank you so much!

[briandennehy]

I had this exact situation arise recently and wasn't sure if it was possible. Thanks Alan!

[JoshMotley-wp]

This is great! Any way to have no data in the PQ table if no selection is made? Mine defaults back to the previous selection's data

[IvanCortinas_ES]

Excellent demonstration of the versatility of Power Query. Great video. Thank you Alan.

[tutorielexcelwordetppt]

You just saved my week. Many Thanks for this wonderful video :)

[bishop]

It is even possible to send the cell contents into the WHERE clause of an SQL query in order to filter the data source instead of downloading the database and applying the filter in PwQ

[teoxengineer]

Alan hi, thank you for this very useful tutorial.
As I see, when we change variable from the list, we have to refresh worksheet everytime to extract all values from the table.
How can we automate it without clicking the refresh button?

[Youtubeitv]

Good day Computer gaga please direct me to your video where show how to start up excel for uk49s lotto and generator for winning numbers please Sir as I am new to learning and understanding excel🙏🙏🙏Thank you

[scottsheldon]

Great video! How do I get data between two order dates? I have tried your method for the end date, but I receive an error message saying, "Expression.Error: We cannot apply operator < to types Table and Date.
Details:
Operator=<
Left=[Table]

= Table.SelectRows(#"Changed Type4", each [Patient In Room Start] >= #"Beg Date" and [Patient In Room Start] <= #"End Date")

Thank you in advance for your help

[jerrydellasala]

TIP: If you NAME the cell, a Table won't be created in the Worksheet making the Worksheet neater. PQ will import the Cell's Name and make it a single row, single column table with the header Column1. Guess that's why it's called "From Table/Range"!
Also, although it rarely happens, it's worth converting text in the Name and Extension columns to Lower Case in a Folder Import ti insure that all the files end with .xlsx or whatever.