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 values are formated as text. Example of a job: 2017-DAT-J02

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] ) )
)

1 Reply

  • 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] ) )
)