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: [ Ссылка ]
Master Functions and Syntax in M
[ Ссылка ]
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: [ Ссылка ].
Website: [ Ссылка ]
SUBSCRIBE TO MY CHANNEL
[ Ссылка ]
LET'S CONNECT:
Blog: [ Ссылка ]
Facebook: [ Ссылка ]
Twitter: [ Ссылка ]
LinkedIn: [ Ссылка ]
Thank you for your support!
#ListContains #PowerQuery #BIGorilla
