Forum Discussion

binayjethwa's avatar
binayjethwa
Helper V
3 years ago
Solved

Identify Duplicates based on single field

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 emailprojectValidation
121BinayIndia11221122[email protected]AYes
121BinayMalaysia33321131[email protected]BYes
111jethwasingapore23332[email protected]CYes
111jethwaindia22222[email protected]DYes
112dfdthailand3331[email protected]DNo
114sdfIndonesia333[email protected]DNo 

 

Thanks,

Binay

Need Help
  • mpraka's avatar
    mpraka
    3 years ago

    Hi,

     

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

    Regards,

    Prakash M

2 Replies

  • mpraka's avatar
    mpraka
    Advocate II
    3 years ago

    Hi,

     

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

    Regards,

    Prakash M

  • Nithinr's avatar
    Nithinr
    Resolver III
    3 years ago

    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")