Filter columns on two different tables

[Anonymous]

Hello,

I'm trying to filter two columns from two different tables.  

I tried doing a conditional column where if Description column Contains "Traditional" then "Yes"
or
if Quotes column Contains "Traditional" then "Yes"

Else
"No"

Since the columns are on different tables, it's not working correctly.

Any ideas are greatly appreciated!

[PaulDBrown]

Can you please provide sample data or PBIX file?

[speedramps · Accepted solution]

Please consider this solution and leave Kudos.

Merge the tables using a common key and select the missing field, so you have all the required fields in one table.

You can then filter the rows using the 2 columns.