Calculated Column duplicates

[Anonymous]

Hi,

Would somebody please be able to help me with a calculated column to check in a fact table, if two columns are the same then 1, but if they have already existed once then 0 like in the image below in the output column.

Deleting duplicates can't happen as these are rows of data with more columns.

Row 1	Row 2	Output
1	1	1
2	2	1
2	2	0
3	3	1
2	2	0

Thanks

Liam

[Greg_Deckler · Accepted solution]

You would need an Index column for that to define "before". If you had that you could do this:

Column = 
  VAR __Table = FILTER('Table',[Row 1] = EARLIER([Row 1]) && [Row 2] = EARLIER([Row 2]) && [Index] < EARLIER([Index])
RETURN
  IF(COUNTROWS(__Table) > 0,0,1)

[Anonymous]

@Greg_Deckler

Ignore that, thats worked thanks so much

[Greg_Deckler]

Cool, it wouldn't be the first time I got a bit of syntax wrong as many times I don't actually test these things!!

[Anonymous]

Hi @Greg_Deckler ,

Thankyou for your reply! The formula says the syntax for RETURN in incorrect currently