Forum Discussion
Solved
List missing information in new table
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'[Customer...
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
Hi Matt_JEM ,
Create a new table by this DAX:
PoNumbersNotInFactory =
EXCEPT (
VALUES('ArcSalesMove'[CustomerPoNumber]),
VALUES('InvMovements'[CustomerPoNumber])
)