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: https://youtu.be/lXqRceLYlMQ

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_confirmation=1

LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: https://facebook.com/BIGorilla/
Twitter: https://twitter.com/rickmaurinus
LinkedIn: https://linkedin.com/in/rickmaurinus/

Thank you for your support!

#ListContains #PowerQuery #BIGorilla

Видео Filter Column by List Items (Exact Match) in Power Query канала BI Gorilla