Power Query Filter column using dynamic list

[MichaelSchulz]

I have two tables
One table has the data records.
The second table I hope to use to filter the first table.
The second table is this:

FilterType	Text
contains	BUILDING
contains	BOX
ends with	AA
ends with	PANEL

Over time, records may be edited, added, or deleted.

I want to use the information in this table to filter a DESCPRITION column in the other table.

I know how to filter using List.Contains; the trouble I have is filtering EndsWith dynamically with multiple values.

 

[MichaelSchulz]

I found a solution using a variation on this:

Re: List as input criteria for Text.StartsWith

Hi , I combine the two tables into one, and it's easy to comparable, please review the following steps. 1. Add a customer coumn using the formula. = Table.AddColumn(#"Changed Type", "Custom", each Table.AddColumn(Table1,"Allranges",each Table1)) 2. Expand the Ranges column, you will get...

community.powerbi.com