Stock Allocation by Order Date (FIFO)

[AAMD123]

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

[adoble0214]

I am also needing this type of allocation assistance!

[v-chenwuz-msft]

Hi @AAMD123 ,

Please copy your formula here, some parts are not visible. Please share your files that do not contain sensitive information. Or a table, not a picture.

Or give some sample data and expected results like the case of the link you provided.

Best Regards

Community Support Team _ chenwu zhu

[AAMD123]

Hi Chenwu,

Thanks for your replay and support !!

Please find the link for the file so you can check it

https://docs.google.com/spreadsheets/d/1V38oEuXf2SeGk_Cy86ThH1q1yMcP6EDE/edit#gid=1035349882 

Best regards,

[v-chenwuz-msft]

Hi @AAMD123 ,

I don't see how the results you want are calculated. Can you explain it?

Best Regards

Community Support Team _ chenwu zhu

[AAMD123]

@v-chenwuz-msft thanks for your replay

I try to explain to you by below capture,

Let say an example in my sheet ( Report ) there are several products and per each product there are several orders against it,

and these orders there are delivery dates for it,

and I calculate the produc's stock as mention dublicated against each order,

what i want is to allocate product stock per each order but should be allocating as per order delivery date

I hope that I deliver my point