Forum Discussion
Stock On Hand Measure From Stock-In Table and Sales Table
I need to create a measure that caulculates the stock on hand at any given day for an item based on a sales table: ITEM SALE_AMOUNT SALE_DATE A 1000 2022-05-23 B 500 2022-05-23 ...
Thanks for the help amitchandak, ideally the stock on 20th May would be 14400 (total stock less 100 of item A sold). I will try your suggestions later today.