Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Shreeram04
Resolver II
Resolver II

Check Duplicate in a column

Hi All,

 

I need to compare two column values.

 

For example in the given below table

TypeID
Nationala
Nationalb
Nationala
Privatea
Private c

 

I need to compare two columns (Type and ID) if values are repeated I need to put 1 otherwise 0, example the combination of national-a is repeated two times so I need to put value 1 for both these columns and for national-b it should be 0 because it is not repeated.

 

The final table should be like this

TypeIDFlag
Nationala1
Nationalb0
Nationala1
Privatea0
Private c0

 

Please help to identify a solution. Thanks in advance.

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@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_0-1670945254106.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
DataInsights
Super User
Super User

@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_0-1670945254106.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.