Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Get duplicate values in same column with iteration wise

Hi , I have a scenario where i have to find duplicated values with in a column and return 1 or 0 as a output Excel vlookup i have - +IF(ISERROR(VLOOKUP(AI2,$AI$1:AI1,1,0))=FALSE,0,1)  the duplic...
DAX
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous,

Any other field that can be used as an index column?
The current power bi data model table does not include row and columns index, I think you need to add an index column and use it as a condition to loop through table records.

Duplicate =
VAR dCount =
    COUNTROWS (
        FILTER (
            Table,
            Table[Number] = EARLIER ( Table[Number] )
                && Table[Index] <= EARLIER ( Table[Index] )
        )
    )
RETURN
    IF ( dCount > 1, 1, 0 )

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi.
i have tried using the formula which you shared but i am facing the error . i have removed extra brackets in return statement but still the error is coming.
Please see the screenshot attached 
The source i have connected is excel and  count of records is approximately  31K. Any suggestions please


Thanks