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

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