Calculate the Inventory OnHand Qty (FIFO) is remaining from which purchase transaction

MahmoudElgendi — Sun, 19 Feb 2023 12:58:57 GMT

Dears,
I’ve Purchases transactions for Items, and also sales transactions.

The requirements: assumes that the OnHand Qty as of Today is 748 Pcs,
I want a way to know from which purchase transactions these qty came from, assuming that FIFO is the inventory method (First In First Out)

In Excel, I used Offset and some other formulas

The result should be like that:

And the clean version keeps only the lines with Qty OnHand like that:

Then, I will create Aging for these Qty as I need to know how long this item is idle in the warehouse.

I want to achieve the same with DAX, I am attaching the Excel file.

I wish if someone can help me with this data and not to refer to other forum posts, as the Aging pattern will not work correctly until we do the same in the screenshot.

I uploaded the Excel file here, I need the result using DAX in Power BI
link to the file: https://rb.gy/vwtgbd

Re: Calculate the Inventory OnHand Qty (FIFO) is remaining from which purchase transaction

amitchandak — Mon, 20 Feb 2023 01:44:25 GMT

MahmoudElgendi , refer if this approch can help

https://radacad.com/dax-inventory-or-stock-valuation-using-fifo

topic Re: Calculate the Inventory OnHand Qty (FIFO) is remaining from which purchase transaction in DAX Commands and Tips

Calculate the Inventory OnHand Qty (FIFO) is remaining from which purchase transaction

Re: Calculate the Inventory OnHand Qty (FIFO) is remaining from which purchase transaction