Identify Duplicates based on single field

[binayjethwa]

Hi ,

Is there any way we can identify duplicates based on single column, Although the values on different colums are different for same Person. Please check on below data.

Here employee Binay is having duplicates , since he is available in India and Malaysia although his other fields are different i.e differnt projects he is working.

So i need a column to identify whether he is working on multiple projects and if he is return Yes, else NO , the unique identifier is Emp no. Can you please help on how to resolve this.

Emp no	Name	country	phone	email	project	Validation
121	Binay	India	11221122	asd@asd.com	A	Yes
121	Binay	Malaysia	33321131	asd@ad.com	B	Yes
111	jethwa	singapore	23332	add@aaa.com	C	Yes
111	jethwa	india	22222	aaaa@ase.com	D	Yes
112	dfd	thailand	3331	ad2@sa.com	D	No
114	sdf	Indonesia	333	23@d.com	D	No

Thanks,

Binay

[Nithinr]

If you want to use Calculated column, Try below Dax

Validation = 
Var Emp = [Emp No]
var counts = CALCULATE(
    COUNTROWS(EmployeeTable),
    ALL(EmployeeTable),
    EmployeeTable[Emp No] = Emp
)
RETURN
IF(counts>1,"YES","NO")

[mpraka · Accepted solution]

Hi,

Yes or No = if(CALCULATE(COUNT('Project Duplicate'[ID]),ALLEXCEPT('Project Duplicate','Project Duplicate'[ID]))>1,"Yes","No")

Regards,

Prakash M