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'[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
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
2 Replies
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 ResultHi Matt_JEM ,
Create a new table by this DAX:
PoNumbersNotInFactory = EXCEPT ( VALUES('ArcSalesMove'[CustomerPoNumber]), VALUES('InvMovements'[CustomerPoNumber]) )
