Forum Discussion

Whatever1's avatar
Whatever1
Icon for Helper I rankHelper I
5 years ago
Solved

How to use a parameter in an expression in M

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([FilterColum...
Need Help
  • camargos88's avatar
    camargos88
    5 years ago

    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))
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
5 years ago

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's avatar
Whatever1
Icon for Helper I rankHelper I
5 years ago

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

 

Thanks