Forum Discussion
unclejemima
Post Patron
Post PatronSum inventory quantity in another table
I've got a table called STOK and one called INVENTORY. Each table has a record called InvUnq what is the inventory unique number. The STOK table has multiple lines in it showing the stock transa...
Hey,
due to the fact that the INVENTORY table has on line per item you can leverage the power of relationships. Create a relationship between the table INVENTORY on the one side and the table STOK on the many side like so:
This allows to create a calculated column inside the INVENTORY table using this DAX statement:
Column = CALCULATE(SUM('STOK'[Qty]))Hopefully this is what you are looking for.
Regards,
Tom
unclejemimaPost Patron
Post PatronThanks!
Is is possible to do this as column not a measure?
TomMartens
Super User
Super UserHey,
as I stated just create a calculated column in the inventory table:
Regards,
Tom
- unclejemima
My appologies, I misread. Thank you so kindly!