Filter the contents of a table based on parameter of type Query in Power Query

[anushavikram]

Hi, 

Im new to power query. Im trying to filter a table based on a list of values passed as parameter. 

Something like this. 

dolphin_code is generated from another table by taking distinct values of a column. Something like below. 

let
Source = Sql.Database("HOTEDWSQL01", "EDW_Reporting"),
dbo_dim_outlet = Source{[Schema="dbo",Item="dim_outlet"]}[Data],
#"Filtered Rows" = Table.SelectRows(dbo_dim_outlet, each ([is_orbit] = "No") and ([dolphin_code] <> null)),
dolphin_code1 = #"Filtered Rows"[dolphin_code],
#"Removed Duplicates" = List.Distinct(dolphin_code1)
in
#"Removed Duplicates"

I applied rthis parameter as a filter on a column of a different table. 

The M code genrated was like this. 

Table.SelectRows(#"Filtered Rows2", each Text.Contains([store_id], BranchCode))

I modified this to 

= Table.SelectRows(#"Filtered Rows2", each List.Contains([store_id], BranchCode))

so as to filter by all the values in paramter and not just currennt value. 

This gives me an error as below. 

Kindly help. 

[v-frfei-msft · Accepted solution]

Hi @anushavikram ,

Please change the Suggested value to list of values to have a try. 

Regards,

Frank