Forum Discussion

asodhani's avatar
asodhani
Frequent Visitor
8 years ago
Solved

How to create new column based on duplicate values

I want to create a column Duplicate Contracts . I use to do this in excel by   B3 and B2 are row numbers for Contract Number for column.   =IF((B3-B2)=0,"Duplicate","Not Duplicate")   I cannot ...
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Then just change the code from the original calculation I sent to use the name of the index column you just added where I have highlighted below.

     

     

    Column = 
VAR CountOfRows = 
    CALCULATE(
            COUNTROWS('Table1'), 
            FILTER( 'Table1' , 
            'Table1'[Contract Number] = EARLIER('Table1'[Contract Number]) && 
            'Table1'[Index Column] > EARLIER('Table1'[Index Column])
            )
            )+0
RETURN IF(CountOfRows=0,"Not Duplicate","Duplicate")

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Then just change the code from the original calculation I sent to use the name of the index column you just added where I have highlighted below.

 

 

Column = 
VAR CountOfRows = 
    CALCULATE(
            COUNTROWS('Table1'), 
            FILTER( 'Table1' , 
            'Table1'[Contract Number] = EARLIER('Table1'[Contract Number]) && 
            'Table1'[Index Column] > EARLIER('Table1'[Index Column])
            )
            )+0
RETURN IF(CountOfRows=0,"Not Duplicate","Duplicate")

 

asodhani's avatar
asodhani
Frequent Visitor
8 years ago

Hi Phil_Seamark

 

Thanks for your help!

 

Its working for me now.

 

Cheers

 

Abhi