Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Summarize projects without audit date

Hello,   I have 2 Data Sources. (Data samples below)   ProjectsDB ProjectID A630BDP 433SRMA A630POB 433PPC 433PED 433BUP A325WLO 433FRI     ProjectAuditsDB P...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    HI Anonymous

     

    Try with this:

     

    ProjectAuditsDB_NOT AUDITED = SUMMARIZE(Filter(ProjectsDB;COUNTROWS(RELATEDTABLE(ProjectAuditsDB))=0);ProjectsDB[ProjectID])

Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

HI Anonymous

 

Try with this:

 

ProjectAuditsDB_NOT AUDITED = SUMMARIZE(Filter(ProjectsDB;COUNTROWS(RELATEDTABLE(ProjectAuditsDB))=0);ProjectsDB[ProjectID])

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    YES!

     

    You did it again Vvelarde!

     

    Thank you.

    J