If string contains a value from another table then get value from that table

[Anonymous]

Hello

I have 2 tables:

Table 1 include grocery store names in a city and its addresses:

Grocery store names	Address
Small region 1 Walmarts	Street A 1
491801 Small region 2 Target	Street B 1

Table 2 include small regions and big region names:

Small Region	Big Region
Small region 1	Big region 1
Small region 2	Big region 2

I want to make a new column in Table 1 that is:

if Table1[Grocery store names] contains Table2[Small Region] then Table1[Address] & Table2[Small Region] & Table2[Big Region]

else Table1[Address]

Sample outcome table:

Grocery store names	Address	New column
Small region 1 Walmarts	Street A 1	Street A 1 Small region 1 Big Region 1

How can I achieve this?

Thank you before hand!

[Anonymous · Accepted solution]

I found solution in this post: https://community.powerbi.com/t5/Desktop/joinAlgorithm-and-keyEqualityComparers/m-p/182148#M79842