Forum Discussion
Count Duplicates based on 2 column in Table
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")
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")
2 Replies
- amitchandak
Super User
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")