Forum Discussion
Calculation of age Days based on FIFO Inventory method
Dear Experts, amitchandak Greg_Deckler I am looking for the help to calculate aging days based on the FIFO method of inventory from the two tables (Both tables have relationship based on Material ...
geemian93 See if these help:
Delivery Dates - Microsoft Power BI Community
Order Fulfillment - Microsoft Power BI Community
If not, I'll try to take a closer look when I have some spare time.
Greg_Deckler Thanks for your response.
I had a look into the proposed article, however it accumulates the item quantity with earliest possible delivery date.
The problem that I am facing is actually simpler since I just wanted to assign age (in days from current or specific date) deducting the most recent purchased quantity from the closing quantity of particular item until the closing quantity reaches "Zero" then leave rest of the purchase history line items age days to "0".
Apprecite if you can spare some time to look into this.
Regards
Waseem