How to use a parameter in an expression in M

[Whatever1]

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 solution]

@Whatever1 ,

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))

[Whatever1]

I was trying to build part of the expression in the variable but, once I saw your post, it seemed obvious.

Thanks