Calculated column duplicates

[Anonymous]

Hello

Could someone help me with a calculated column to record a fact table, if two columns are equal then 1, but if they have already existed once then 0 as in the image below in the output column.

Duplicate deletion cannot occur, as these are rows of data with more columns.

Row 1	Row 2	exit
1	1	1
2	2	1
2	2	0
3	3	1
2	2	0

Thank you

Liam

[Mariusz · Accepted solution]

Hi @Anonymous 

You can add Index in Power Query or use an existing if you have one, and later add the column as per below.

Column = 
VAR __row1 = 'Table'[Row 1]
VAR __index = 'Table'[Index]
RETURN 
INT( 
    IF(
        __row1 = 'Table'[Row 2],
        COUNTROWS(
            FILTER(
                'Table',
                'Table'[Index] < __index 
                && 'Table'[Row 1] = __row1
                && 'Table'[Row 2] = __row1
            )
        ) = 0
    )
)

The result will be 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[amitchandak]

@Anonymous , if logic is based row1 and row 2, it is not very clear

[Anonymous]

Hi @amitchandak ,

I just needed the system to pick up on a match and if its already happened somehow,

I dont know whether thats possible