Print values from a row based on a condition

[dt_2023]

Hi all,

I'm looking to create a column in a table "Source" that display only specific values from a row that matches the condition. The table row for Column ID meets more than one condition. For example: I have a table called "Source" that contains column ID and another table "Category"

Source #

ID

gpl 3.0, mpl 1.0

gpl 2.0, gpl 3.0

mpl 1.0, gpl 2.0

apache 2.0, mpl 1.1

apache 2.0, gpl 3.0, gpl 2.0

Category:

ID	Category
gpl 2.0	Graylist
gpl 3.0	Blacklist
mpl 1.0	Graylist
mpl 1.1	Blacklist
Apache 2.0	Whitelist

Is there a way to filter values based on a category and display only the values specific to a category, even though the row contains values from all 3 categories.

[Fowmy · Accepted solution]

@dt_2023 

In Power Query split the ID column in to rows based on delimiter comma. Then you can create a relationship to the Category and filter the records in the source table based on the category selected.