How to create a column to check if two column values are both match?

[Anonymous]

Hi,

I want to create a column to check both two column values are match. Plesae see example below:

Name	Country	Item#
A	A	1
B	A	2
C	B	1
D	B	3
E	C	2

I want to create a column to return "y" if there is other row has same Item# but with different Country, return "n" if there is no other row that has same Item# with different Country.

Desired Result Below:

Name	Country	Item#	_Check
A	A	1	y
B	A	2	y
C	B	1	y
D	B	3	n
E	C	2	y

Thanks!

[ryan_mayu · Accepted solution]

@Anonymous 

pls try this

_check = 
VAR result=maxx(FILTER('Table','Table'[Item#]=EARLIER('Table'[Item#])&&'Table'[Country]<>EARLIER('Table'[Country])),'Table'[Country])
return if (result="","n","y")