Forum Discussion
Compare 2 Columns in different Tables
If you don't have additional data transformations after this step, it would be easier to do this kind of comparison in a DAX calculated column. So I suggest your load the tables and compare the values with LOOKUPVALUE() or some other way.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Hi,
I have 2 tables
Table A
Unique ID Column 1 Column 2 Column 3
1 abc once France
2 def twice Germany
3 ghi three US
4 abc twice Germany
5 ghi five UK
Table B
Unique ID Column 1 Column 2 Column 3
1 fafa 1 France
2 agsasg 3 UK
3 agas 7 US
4 afsf 3 Germany
5 agag 5 UK
I want a new column to be created (in either table) that shows when the column 3 values in rows from each table match, as below:-
New Table B
Unique ID Column 1 Column 2 Column 3 Column 4
1 fafa 1 France Match
2 agsasg 3 UK No Match
3 agas 7 US No Match
4 afsf 3 Germany Match
5 agag 5 UK Match
Many many thanks in advance
Grant