39 - Extract Data from a Table based on User Selection in Excel using Power Query

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