Forum Discussion

hgalfre's avatar
hgalfre
Helper I
5 years ago
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...
Need Help
  • d_gosbell's avatar
    d_gosbell
    5 years ago

    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)
d_gosbell's avatar
d_gosbell
Super User
5 years ago

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)