Okay I am sure there is a simple answer but I have been trying to no avail
I have a VC that is a reference to a table with SKUs that are related to a product its a 1:n relationship where 1 is the inventory and n is the related SKUs. So for a product say there could be 2 relationships.
I need another column that would take the VC values (the 2 relationships from above) of vendor_sku AND check if it exists in another table that is a reference of the SKU to the vendor SKU and that way I can count how many stock items we have.
Maybe I am making this complicated, here is the formula I am using:
SELECT(inventory_adjustment[adjustment], IN([vendor_sku], [related_vendor_inventory_skus][vendor_sku]))
Expression clears but then what happens is EVERY row comes back instead of what is actually just in the related skus - the 2 results.
Hopefully I am explaining this right.