How to use a parameter in an expression in M

Question

I want to dynamically change a variable and use it to filter rows.

let

Variable = "ABC",

Source = anything,

#"Filtered Rows" = Table.SelectRows(source, each Text.Contains([FilterColumn], "ABC") )

in

#"Filtered Rows"

works where [FilterColumn] is a column returned in the source query.

What I want to do is something like:

#"Filtered Rows" = Table.SelectRows(source, each Text.Contains([FilterColumn], Variable) )

so I can change the variable based on something else and get different results.

However, nothing I try seems to work. There must be a way to dynamically build an expression.

Amy Ideas?

camargos88 · Accepted Answer

Whatever1&nbsp;,
&nbsp;
How are you applying it ?
I just tried it with a custom column and it worked.
let _variable = "A" in

Table.SelectRows(#"Changed Type", each Text.Contains([Value], _variable))

Forum Discussion