Stock On Hand

Question

Hello , im trying to archieve the following measure :&nbsp;i need to calculate the actual stock in every month&nbsp; , starting from a inicial stock adding the customers buy and substracting the customer sales :&nbsp;&nbsp;i have the folowing tables :&nbsp;sell in : are the products wich each reseller buy to my company&nbsp;&nbsp;sell out : are the sales from each reseller to final customerinicial stock : the inicial stock in every product in every customer&nbsp;&nbsp;I can also attach a pbix with this example&nbsp;&nbsp;what i need to do is :&nbsp; &nbsp;date&nbsp; &nbsp; &nbsp; &nbsp;customer&nbsp; &nbsp; &nbsp; &nbsp; sku&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sell in&nbsp; &nbsp; &nbsp; Sell Out&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Stock&nbsp;&nbsp;2020-02 | Customer1 | PROD001 |&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp;273&nbsp; &nbsp; &nbsp; | (previous month stock +sell in - sell out)&nbsp;&nbsp;&nbsp;&nbsp;

amitchandak · Answer

Anonymous , You have use Intial stock + Cumalative Sell in - Cumalative Sell out
&nbsp;
Qunatity on hand = [Intial stock] + CALCULATE([Sell in],filter(allselected(Date),Date[Date] &lt;=max(Date[Date]))) -CALCULATE([Sell out],filter(allselected(Date),Date[Date] &lt;=max(Date[Date])))