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