39 Extract Data from Table Using Power Query in Excel

In this video, I will show you how to extract the data from a table based on the selection a user makes. For this video, I take an example of a drop-down where as soon as the user makes the drop-down selection and refreshes the query, the data updates and give the relevant records.

✅ Power Query Course Download files: https://trumpexcel.com/course-download-files/

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

------------------------------------------------------------------------------
0:00 Introduction
0:13 Overview of the data and goal
0:33 Creating a unique items list with Power Query
1:10 Setting up the dropdown selection
2:30 Creating a Power Query connection to get the selection
3:33 Setting up the main data query
4:30 Connecting the dropdown selection to the filter
5:22 Demonstrating the dynamic filtering in action
------------------------------------------------------------------------------

#Excel #ExcelTips #ExcelTutorial