Forum Discussion
akhaliq7
Post Prodigy
Post ProdigyThe equivalent of NOT IN (SQL) in power query
I am currently using a sql native query and wish to use power query instead. I have a select subquery that uses a not in function like the one below: (
SELECT DISTINCT MAX(column1)
FROM Table1 tb
W...
It's the equivalent to
= Table.SelectRows(TableOrPriorStepName, each not List.Contains(ListOfInValues, [ColumnToCheck]))
--Nate
It's the equivalent to
= Table.SelectRows(TableOrPriorStepName, each not List.Contains(ListOfInValues, [ColumnToCheck]))
--Nate
AlexisOlson
Super User
Super Userakhaliq7 Note that what Anonymous gave is equivalent to a simpler SQL expression:
SELECT *
FROM TableOrPriorStepName
WHERE [ColumnToCheck] NOT IN ListOfInValues