Forum Discussion
Solved
Count duplicates depending on two columns
Hi there! I'm helping a colleague project manager and sometimes, when creating a new project, the database gives twice the same Project number to 2 different projects. I want him to be able to...
If you want to extend the FITLER comparison to check both the project number and the status you can use the && operator which does a logical AND.
eg.
IF(COUNTROWS( FILTER ( Projects, Projects[N° project] = EARLIER ( Projects[N° Project] ) && Projects[Status] = EARLIER(projects[Status]) ) ) > 1,1)
Thank you! That worked fine (I had tried only with one & and without the 2nd earlier).