Alternative to SQL IN operator - Power Query M formula language

[Zyg_D]

What is the best SQL IN alternative using Power Query M formula language (not DAX)? 

[Greg_Deckler]

@Zyg_D - In Power Query, there are numerous ".Contains" functions for elements like List, Table, Text, etc.

[amitchandak · Accepted solution]

@Zyg_D , In DAX you have In

Table[Col] in {"1","2","3"}

Table[value] in {1,2,3}

Power Query it will be

List.Contains({'Value1', 'Value2', 'Value3'}, [Column1])

refer

https://stackoverflow.com/questions/51740679/power-query-m-the-in-operator

https://community.powerbi.com/t5/Desktop/IN-OPERATOR-in-PowerBi/td-p/174285