cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

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([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?

 

   

1 ACCEPTED SOLUTION
Super User III
Super User III

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
Super User III
Super User III

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

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

 

Thanks

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors