Forum Discussion

aewing13's avatar
aewing13
Frequent Visitor
2 years ago
Solved

Multiple Duplicate Tests

Hi all,   I'm curious if there are any ideal methods for performing multiple duplicate tests on the same table, each testing different columns.   For example, from the below, I'd like to identify...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Write these calculated column formulas

    Column = 1*(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[ID]=EARLIER(Data[ID])&&Data[Invoice]=EARLIER(Data[Invoice])))>1)
    Column 2 = 1*(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[Date]=EARLIER(Data[Date])&&Data[Amount]=EARLIER(Data[Amount])))>1)

    Hope this helps.

     

aewing13's avatar
aewing13
Frequent Visitor
2 years ago

This works perfectly. Thank you!

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

You are welcome.