Forum Discussion

binayjethwa's avatar
binayjethwa
Icon for Helper V rankHelper 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
Icon for Advocate II rankAdvocate 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