Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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")
Solved! Go to 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 , 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")
thanks Amir as always...... prefect
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |