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 ...
Anonymous , what would stock on 20th May. blank or 14500. Create a date table join with both the tables on date
For stock try a meausre like
calculate(lastnonblank(Date[Date], sum(Stock[Quanity]), filter(all(date), Date[date]<= max(Date[date])))