How to filter correctly in Power Query
Filtering is probably the most common transformation in Power Query. However, there are a few things to consider to achieve the desired result. I'll show you how to optimally filter in Power Query.
📊 SAMPLE FILES 📊
The sample files used are available free of charge for subscribers to my newsletter: http://eepurl.com/cmkOEz
🎓 VIDEO COURSE 🎓
My comprehensive Power Query beginner's course with 160+ videos – everything about data import and automation:
https://myablefy.com/s/ssbi-blog/powe...
👨🎓 TRAININGS 👩🎓
My Power BI online training courses https://ssbi-blog.de/power-bi-schulungen
🥷 CONSULTING 🥷
Want to book a consultation? Click here: https://calendly.com/ssbi-blog/15min
📹 CONTENT 📹
00:00 Intro
00:08 Hello + Topic
00:20 Sample Data
00:35 Filtering via the User Interface
04:34 Filtering via Lists
11:15 Filtering via Multiple Columns with Joins
14:38 Filtering via Multiple Columns + Condition
16:35 Filtering with a Check Column
18:38 Filtering via Multiple Columns
28:40 Closing Words
🙋♂️ CONTACT 🙋♂️
Website: https://ssbi-blog.de/
LinkedIn: / lars-schreiber-power-bi
Twitter: / schreiberlars
🤿 SETUP 🤿
https://kit.co/LarsSchreiber/office-s...
#powerquery #powerbi #excel