Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

FIFO Consumption

Hello Experts

how can we Sale this item in Fifo Order. once the 1st Purchase is consumed then only it should take from the 2nd Purchase

what is the way to acheive it.

In this Eg: once item A has with 500 Qty. till that 500 qty was consumed it should take from the 2nd Purchase of 300 qty.



Super User
Super User

You are not currently indicating the order of the rows.  You need to provide guidance on how to sort your input data in the right order (with an index column for example).  Then you need to explode the item amounts into individual rows and then use the "keep top rows" and "drop top rows" mechanics to apportion the sales.


Your sample data does not describe your issue sufficiently. Please provide better sample data that covers all scenarios.


Helpful resources

Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Kudoed Authors