Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
8 years ago
Solved

Show Missing Data

I have two tables: BWJobs and ProjectJobs. Both have a "JobNumber" column.   I need to be able to show JobNumbers in BWJobs that aren't showing up in jobNumbers in ProjectJobs and vice versa. the v...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi bhmiller89

     

    Add a new Table from the Modelling Tab

    MissingJobs =
UNION (
    EXCEPT ( VALUES ( BWJobs[JobNumber] ), VALUES ( ProjectJobs[JobNumber] ) ),
    EXCEPT ( VALUES ( ProjectJobs[JobNumber] ), VALUES ( BWJobs[JobNumber] ) )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi bhmiller89

 

Add a new Table from the Modelling Tab

MissingJobs =
UNION (
    EXCEPT ( VALUES ( BWJobs[JobNumber] ), VALUES ( ProjectJobs[JobNumber] ) ),
    EXCEPT ( VALUES ( ProjectJobs[JobNumber] ), VALUES ( BWJobs[JobNumber] ) )
)