Lookup text from unrelated tables

[Anonymous]

Hello there,

Am trying to overcome this issue where I want to compare 2 texts (Names) from 2 different unrelated tables tables.

While applying all DAX seen in similar post, I couldn't find see tables names present when "SEARCH" function was applied.

I posted some images to help you understand how both tables looks:

Names are removed here; however the goal is to creat a new column in the Left table called "Match", with "X" in case Name is matched with Name in the Right table (Finance FTE).

Your support & help is much appreciated.

Thank you,

Mobafa

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated column.

Column =
IF(
    'Name List FTE'[Name] in SELECTCOLUMNS('Finance FTE',"1",[Name]),"X",BLANK())

2. Result:

If you need pbix, please click here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Hi @v-yangliu-msft ,

Thank you for your response.

The method you provided work partially and I guess it's because of Exact match problem.

Is there a way in DAX the I could perform a query such as a fuzzy match i.e.(approximate)?

Thanks again,

Mobafa

I have an issue where the table 

[Ashish_Mathur]

Hi,

Write this calculated column formula in the left table

Match = if(calculate(countrows(lefttable),filter(righttable,righttable[Name]=earlier(lefttable[name])))>0,"X",blank())

Hope this helps.

[amitchandak]

@Anonymous , Assume I want to search a part of text from Table 1 to Table 2

New column in table 2

New columm=

var _cnt = countx(filter(Table2, search(Table1[Column], Table2[Column],,0) >0) , Table2[Column])

return

if(isblank(_cnt), "Not Found", "Found")

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8