The IN Operator in Power Query

Looking for the IN Operator equivalent in Power Query? This video shows you exactly what you need.

WRITTEN ARTICLE:

CONTENT
00:00 Introduction
01:41 IN operator single column
03:54 Reference Table Values
05:34 IN Operator multiple columns

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#INoperator #powerquery #bigorilla

[SMITDEDHIA]

Jordaar chho tame bhai. Massively underrated 🙌

[zahoorsarbandi]

Excellent video... there are a lot for learning in just a 10 minutes video.

[pravinshingadia]

Your videos are brilliant. One of the best I have seen.

[wayneedmondson]

Awesome tips and techniques! Thanks for sharing. Thumbs up!!

[YTFC]

Excellent! Thank you and from your explanation I learned additional things too!

[williamarthur]

Really like the table contains version, had an experiment ; this is add col but will work as filter ;

= let pc = { {"Jeans", "Blue"}, { "Shirts", "Red"}}
in
Table.AddColumn( Source, "N",
each List.Accumulate( pc, false, (s, c)=>s or c {0} = [Product] and c {1} = [Color]
))

[Jamieemmart]

Very good Rick. I have been doing this with merging which is powerful but limits me to similar combinations. The technique shown here with Table.Contains will let me do the equivalent of filter for: blue socks or yellow jeans with pockets or green jeans. So much better! I’ll definitely need List.Buffer though…

[Lyfisbtfl]

Really it's very useful video 👏👏..Request you to pls upload more videos like this ..Thank you ❤❤❤

[ВиталийШубин-кэ]

Thanks for this great video! It's very helpful. Happy New Year!

[orleanCosta]

Amazing! I enjoy your videos a lot. Thank you.

[NMVJ]

Thanks Rick for this excellent content :)

[dicky]

Great video, really simplifies power querying . That's just what I need

[skimpylemon]

Nice and simple, straight to the point! Thanks man! Subbed!

[bagnon]

Can this be done with the filter function?

[roywilson]

Another great and useful video, thanks

[Faisal]

Thank you for sharing this, is there a way to track values changes after refresh a power query in excel

[Sumanth]

Excellent content 😊👍 just curious if it's faster then to use merge..I generally create a criteria table in such a scenario..

[ExcelInstructor]

GReat :)
Perfect Even :)
I do however have a question.
I know I can filter a Table by a List of Values,
but from what I see it could be possible to filter Table A, by Table B,
Can you help out figuring out the code?

Ok after a bit of playing with some most basic tables:
= Table.SelectRows( Custom4, each Table.Contains(Table4, [[AmountOfSales], [DateOfShipment]]))

This is amazing!!!
Recently Ihad to filter a Table by multiple Lists and I was going creazy!
Thank you for showing Table.Contains function!!!
Wow.

[toynkaccounting]

Great video Rick. Question about the returned data. Instead of using a static value like "Sale", is it possible to return a value from a column in the ProductAndColor table?

[rubenmunozverdu]

Are there any faster alternatives? List.Contains is quite slow for big tables :(