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 ...
Hi
Try This
Stock situation =
VAR stockdatevalue =
SELECTEDVALUE ( 'Date'[Date] )
VAR stockqty =
CALCULATE (
SUM ( Stock[Stock] ),
ALL ( 'Date'[Date] ),
Stock[Date] <= stockdatevalue
)
VAR salesqty =
CALCULATE (
SUM ( 'Stock SALES'[sales] ),
ALL ( 'Date'[Date] ),
'Stock SALES'[Date] <= stockdatevalue
)
RETURN
stockqty - salesqty