Forum Discussion
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
- v-chenwuz-msftCommunity Support
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
- AAMD123Regular Visitor
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-msftCommunity Support
Hi AAMD123 ,
I don't see how the results you want are calculated. Can you explain it?
Best Regards
Community Support Team _ chenwu zhu
- adoble0214Frequent Visitor
I am also needing this type of allocation assistance!