List missing information in new table

[Matt_JEM]

Good day Everybody.

I have a table 'ArcSalesMove[CustomerPoNumber] directly from our Syspro SQL server that contains all the CustomerPoNumbers in the system. Another table 'InvMovements'[CustomerPoNumber] have all the only the CustomerPoNumbers that is now in the factory.

How do I creat a new table thet will list both the 'ArcSalesMove[CustomerPoNumber] and 'InvMovements'[CustomerPoNumber] next to one another so that I can find the create a list of CustomerPoNumbers that is not in the factory.

I thank you in advance for your assistance.

Matt

[Bibiano_Geraldo]

Hi @Matt_JEM ,

Create a new table by this DAX:

PoNumbersNotInFactory = 
    EXCEPT (
        VALUES('ArcSalesMove'[CustomerPoNumber]),
        VALUES('InvMovements'[CustomerPoNumber])
    )

[johnt75 · Accepted solution]

You can create a table of PO numbers not in the factory with

Not in factory =
VAR AllNumbers =
    DISTINCT ( 'ArcSalesMove'[CustomerPoNumber] )
VAR InFactory =
    DISTINCT ( 'InvMovements'[CustomerPoNumber] )
VAR Result =
    EXCEPT ( AllNumbers, InFactory )
RETURN
    Result