Forum Discussion

Shreeram04's avatar
Shreeram04
Resolver III
3 years ago
Solved

Check Duplicate in a column

Hi All,   I need to compare two column values.   For example in the given below table Type ID National a National b National a Private a Private  c   I need to compa...
General Comment
Need Help
Tips and Tricks
  • DataInsights's avatar
    DataInsights
    3 years ago

    Shreeram04,

     

    Try this calculated column:

     

    Flag = 
VAR vType = Table1[Type]
VAR vID = Table1[ID]
VAR vRowCount =
    COUNTROWS ( FILTER ( Table1, Table1[Type] = vType && Table1[ID] = vID ) )
VAR vResult =
    IF ( vRowCount > 1, 1, 0 )
RETURN
    vResult

     

     

DataInsights's avatar
DataInsights
Super User
3 years ago

Shreeram04,

 

Try this calculated column:

 

Flag = 
VAR vType = Table1[Type]
VAR vID = Table1[ID]
VAR vRowCount =
    COUNTROWS ( FILTER ( Table1, Table1[Type] = vType && Table1[ID] = vID ) )
VAR vResult =
    IF ( vRowCount > 1, 1, 0 )
RETURN
    vResult