Filter "column" where "column" is picked from a parameter or a list

[jmdh]

Hi ,

I am struggling to make the expression 

Table.SelectRows( Sales, each ([Product] <> "P1"))

work when i am trying to repace teh actual column name [Product] with something either coming from a List, or a parameter

Table.SelectRows( Sales, each (   Parameter <> "P1"))

I have no syntax error but it is as though the expression is not evaluated ...

I have tried many options including Expression. Evaluate without success.

Thanks a lot for your input.

[MarcelBeug · Accepted solution]

Here is one option you probably didn't try:

Table.SelectRows(Sales, each Table.Column(_,Parameter) <> "P1")

[jmdh]

Perfect ! (one more time).

Many thanks Marcel,

Jmdh