Compare 2 tables

[MasterSonic]

Hello,

I would like to build a visual pointing me which columns values are different for each IDs between these 2 tables please

table1
Id	Code	OrderNumber	Country
101	x20	10877	FR
102	x43	68447	US
103	43	74649	RU
104	x99	5515	FR
105	x55	95	SG
106	78	2156	CZ
table 2
Id	Code	OrderNumber	Country
101	x20	10877	UK
104	x43	68447	US
105	43	74649	NL
102	x99	5515	JP
103	x55	95	CN
106	78	2156	US
107	88	662	DE

[Anonymous · Accepted solution]

Hi @MasterSonic ,

Please refer to my pbix file to see if it helps you.

Creat a measure.

MeasURE =
VAR _1 =
    MAX ( Table1[OrderNumber] )
VAR _2 =
    MAX ( Table2[OrderNumber] )
RETURN
    IF ( _1 = _2, _1, 0 )

Then set background for the id.

If I have misunderstood your meaning, please provide more details with your desired output.

Best Regards

Community Support Team _ Polly

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