Aging Report using FIFO

Question

I have a database of products that i want to create an aging report using FIFO.

Sample file and outcome: https://we.tl/t-TBFVW2AIw2

Answer 1

Thanks so much for the information Snow Lu

Answer 2

You may need a measure in Power Povit with dax formula. Such as this one.

SumBeforeCurrentDate := VAR CurrentRowDate = MAX(Table1[Posting date]) RETURN CALCULATE( SUM(Table1[Quantity]), Table1[Posting date] < CurrentRowDate )

===================================

I'd suggest you create a new thread on Power query forum which is special channel to handle such questions.

Power Query - Microsoft Fabric Community

Answer 3

Hi Snow,

I got the desired outcome by grouping the products. So initially, I bought 4 bottles on April 30, then on July 4 and Sep 1 there is consumption. Thus the balance is now 1 or simply 22 which was (88/4). and then i bought again on Sep 15 for 5 bottles. Thus in my aging, it should show that on the original purchase in April 30, i still have 1 bottle left or 22 on my 121-365 days and 5 bottles/110 on 31-60 days bracket.

Kind Regards,

Donskie

Answer 4

How do you get 22 and 1635 in 121-365 days? I cannot understand your logical from your desired outcome.