Forum Discussion

AAMD123's avatar
AAMD123
Regular Visitor
4 years ago

Stock Allocation by Order Date (FIFO)

I have a problem that I can't solve with Power Query.

In the work there is an SAP report in which the orders of all the customers are, with quantities ordered, reference stock, date of the order, etc.

 

Kindly find below snapshots for my report:

 

- This Relationship for 2 sheets:

 

 

- This Piovate Table to All Orders against 1 product with the requested delivery date:

 

 

- THIS IS an EXAMPLE of WHAT I NEED TO SHOW UP 

 

 

Note: I tried to find a solution such my case, but I tried but not succeed 😞

 

https://community.powerbi.com/t5/Desktop/Stock-distribution-by-order-date/m-p/1976772#M747937

 

 

 

 

5 Replies