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...
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

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