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.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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.