Hi everyone,
i have a virtual column that show the quantity of a product available.
below is the formula
SUM(SELECT(Inventory[Amount],([Item ID] = [_THISROW].[Item ID])))
is it possible to add another column from a different table
SUM(SELECT(Inventory[Amount],([Item ID] = [_THISROW].[Item ID]))+(AddStock[Amount],([Item ID] = [_THISROW].[Item ID])))
i tried the above formula but the amount added in AddStock will affect all other Item ID and not the specific Item ID that i want.
Solved! Go to Solution.
Just a quick check, unless it is a typo your expression seems to be missing a second SELECT.
SUM(
SELECT(Inventory[Amount], ([Item ID] = [_THISROW].[Item ID]))
+
(AddStock[Amount], ([Item ID] = [_THISROW].[Item ID]))
)
SUM(
SELECT(Inventory[Amount], ([Item ID] = [_THISROW].[Item ID]))
+
SELECT (AddStock[Amount], ([Item ID] = [_THISROW].[Item ID]))
)
Could this be the issue? (but again, I would think your original expression would raise a format error...)
Just a quick check, unless it is a typo your expression seems to be missing a second SELECT.
SUM(
SELECT(Inventory[Amount], ([Item ID] = [_THISROW].[Item ID]))
+
(AddStock[Amount], ([Item ID] = [_THISROW].[Item ID]))
)
SUM(
SELECT(Inventory[Amount], ([Item ID] = [_THISROW].[Item ID]))
+
SELECT (AddStock[Amount], ([Item ID] = [_THISROW].[Item ID]))
)
Could this be the issue? (but again, I would think your original expression would raise a format error...)
thank you very much
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |