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

Re: Using a list parameter as a table filter in M language

Great info...

 

 

Just wanted to know what if your parameters were text-based? I having issues getting the quotation marks to work

nickchobotar Established Member
Established Member

Re: Using a list parameter as a table filter in M language

@Jimenez  My solution was with numeric values. However, List.Contains + All or + Any functions work with strings too. Try wrapping in double quotes the text with quotation marks like so : 

Source

a
"b"
c


= List.ContainsAny(Source, { """b"""})

 

N -