Forum Discussion

PowerbiDev12's avatar
PowerbiDev12
New Member
3 years ago

Fifo concept in power query

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

2 Replies

  • bhelou's avatar
    bhelou
    Responsive Resident

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

    • PowerbiDev12's avatar
      PowerbiDev12
      New Member

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

       

       

       

       

       

      Thanks