How to match 2 different columns from 2 different tables

Siza — Wed, 15 Mar 2023 10:19:42 GMT

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?

Re: How to match 2 different columns from 2 different tables

Anonymous — Fri, 17 Mar 2023 01:44:41 GMT

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

topic Re: How to match 2 different columns from 2 different tables in DAX Commands and Tips

How to match 2 different columns from 2 different tables

Re: How to match 2 different columns from 2 different tables