Fifo concept in power query

[PowerbiDev12]

I have mentioned one table and  what i want , it's like FIFO concept 

1. i have some of Items and amounts and publiction, so i want to show payments as publication wise and need split amount based on invoice number .

Eg 1:

Eg 2:

Payments Logic : Invoice number 1

1st row Collection(3000) - Amount(1000)=Payments1(2000)

2nd row Payments1(2000) - Amount(500) = Payments2(1500)

3rd row Payments2(1500) - Amount(1500) = Payments3(0)

4th row Payments3(0) - Amount(2000) = Payments4(0)

Please let me know if you have solution

Thanks & Regards,

Sakthivel

[bhelou]

hi , please if you can share some sample with the queries , ill try to help you . 

[PowerbiDev12]

i will give sample data , please try with this and let me know if got solution. 

Thanks