How to match 2 different columns from 2 different tables

[Siza]

May you please help me with this problem, I have 2 differnet datasets( Table A and Table B) the tables have a column called a UCR which can be used to link both tables. I want to be able to see the non-matching UCR's that are in table A but not in table B, I used the formula ucr_match = if(RELATED(TableA[UCR])=TableB[UCR], "Match","Non Match")

The problem is that some of the UCR's were wrongly captured by end users which then shows as if there's a non-match when in fact there is a match. Take for example Table A ucr has 4 six's where as table B has 3 six's and these are supposed to be a match. 

Table A                                                             Table B 

UCR: 2JP01536666CINV4300840884M            UCR: 2JP0153666CINV4300840884M

What alternative can I use? 

[Anonymous · Accepted solution]

Hi  @Siza ,

I created some data:

TableA:

TableB:

Here are the steps you can follow：

1. Create calculated column.

Column =
VAR _column=SELECTCOLUMNS('TableA',"UCR",'TableA'[UCR])
return
IF(
    'TableB'[UCR] in _column,"Match","Non Match")

2. Result:

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