Filter Nested Tables before Expanding in Power Query

Check out our newly launched M Language course ↗️ - https://goodly.co.in/learn-m-powerquery/ If you're an avid Power Query user you'll often need to filter nested tables before you expand them in Power Query. In this video I'll share 2 techniques to apply a single or multiple value filter to tables before expanding them. ===== ONLINE COURSES ===== ✔️ Mastering DAX in Power BI - https://goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Course- https://goodly.co.in/learn-power-query/ ✔️ Master Excel Step by Step- https://goodly.co.in/learn-excel/ ✔️ Business Intelligence Dashboards- https://goodly.co.in/learn-excel-dashboards/ ===== LINKS 🔗 ===== Data Loading Tricks - https://www.youtube.com/watch?v=4S_aore7ezg Blog 📰 - https://www.goodly.co.in/blog/ Corporate Training 👨‍🏫 - https://www.goodly.co.in/training/ Need my help on a Project 💻- https://www.goodly.co.in/consulting/ ===== CONTACT 🌐 ===== Twitter - https://twitter.com/chandeep2786 LinkedIn - https://www.linkedin.com/in/chandeepchhabra/ Email - [email protected] ===== CHAPTERS ===== 0:00 Intro 0:28 How Expanding and Filtering works in Power Query 4:40 Applying a single value filter before expanding 8:35 Applying multiple value filter before expanding 12:25 My Courses ===== WHO AM I? ===== A lot of people think that my name is Goodly, it's NOT ;) My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI. Please browse around, you'd find a ton of interesting videos that I have created :) Cheers! - - - - - Music By: "After The Fall" Track Name: "Tears Of Gaia" Published by: Chill Out Records - Source: https://goo.gl/fh3rEJ​ Official After The Fall YouTube Channel Below https://www.youtube.com/channel/UCGQE...​ License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) Full license here: https://creativecommons.org/licenses