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

12K views May 15, 2023

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 Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN