Count Duplicates based on 2 column in Table

[Anonymous]

Hi Experts

How would you amend the following formula to count the if a Regulatory_ID has been re entered with a new action date (ie i need to add the Regulatory_ID column to the below measure, current the measure is only using the actiondate)

Current DAX

Check for Dups = if(countrows(filter('Reg Issues','Reg Issues'[actiondate]=earlier('Reg Issues'[actiondate]))) >1,"Yes","No")

[amitchandak · Accepted solution]

@Anonymous , try like

Check for Dups = if(countrows(filter('Reg Issues','Reg Issues'[actiondate]=earlier('Reg Issues'[actiondate]) && [new action date] < earlier([new action date]))) >1,"Yes","No")

[Anonymous]

thanks Amir as always...... prefect