Show Missing Data

[bhmiller89]

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

[Zubair_Muhammad · Accepted solution]

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