Filter Column by List Items (Exact Match) in Power Query
This video shows how you can create a condition to check if a cell equals a value from a list. You in fact pass a list as filter argument. The method reduces the amount of code required to check a column to be equal to a list of items.
If instead you need to check if a column contains an item from a list, make sure to check my other video: • Check if Column Contains Item from Li...
Master Functions and Syntax in M
https://powerquery.how
00:00 Introduction
00:32 Dataset
00:40 The long UI formula
01:15 Filter cells equal to a value from list
03:10 Condition equal to a list of items
04:00 Down-side: exact match
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: https://paypal.me/rickmaurinus.
Website: https://gorilla.bi
SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...
LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#ListContains #PowerQuery #BIGorilla