Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PowerbiDev12
New Member

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:

PowerbiDev12_0-1676808073200.png

 

 

 

Eg 2:

PowerbiDev12_1-1676808103031.png

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 2
bhelou
Responsive Resident
Responsive Resident

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

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

 

PowerbiDev12_0-1677595947968.png

 

 

 

 

Thanks 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors