Forum Discussion

Frequent Visitor

3 years ago

Need help to Identify Duplicate field

I am trying to find a formula which Identifies the duplicate address and makes it a 1 but keeps the original instance of that address as a 0.

Frequent Visitor

3 years ago

Thank you. Is there another version of this formula which can be used on the data view/data table side vs the power Query side. Thank you

Super User

3 years ago

Hi,

Use this calculated column formula

Column = CALCULATE(COUNTROWS(Data),FILTER(Data,Data[Customer Address]=EARLIER(Data[Customer Address])&&Data[CustomerID]<EARLIER(Data[CustomerID])))+0

Hope this helps.