Forum Discussion
Inventory Value
you need to relate your tables:
and then the measures are easy
RemainingQuantity = SUM( Transactions[Quantity] )
Value =
SUMX(
Items,[RemainingQuantity] * Items[UnitPrice]
)
Anonymous
please post a sample of your data along with expected results
Sample Data:
No | Description | UnitPrice
10 | Adapter |99Entry No | Item No | Quantity | Remaining Quantity
1 | 10 | 1 | 1
2 | 10 | -1 | 03 | 10 | 2 | 2
Goal:
No | Remaining Quantity | Value(Remaining Quanitity * UnitPrice)
10 | 2 | 198
you need to relate your tables:
and then the measures are easy
RemainingQuantity = SUM( Transactions[Quantity] )
Value =
SUMX(
Items,[RemainingQuantity] * Items[UnitPrice]
)Hi Anonymous
Please share your sample table. that would be efficient way to find a solution for you.
Cheers
Hello Gandalf,
If you want to calculate inventory value you should calculate that from the Value entry table. It's more accuarate than the item table.
/ J
