Forum Discussion
Alternative to SQL IN operator - Power Query M formula language
What is the best SQL IN alternative using Power Query M formula language (not DAX)?
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
2 Replies
- amitchandakSuper User
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
- Greg_DecklerCommunity Champion
Zyg_D - In Power Query, there are numerous ".Contains" functions for elements like List, Table, Text, etc.