Pavan.Sada.PS
Member
Hello Fellas,
Need your help and assistance here. I am looking for powerquiery solution as i have data around 10 lakh plus rows to do the calculation for.
To explain about the data: on a daily basis we get the customer orders and we check if the stock is available we allocate them to those customers (we follow FIFO basis ) and bill them accordingly.
In the attached file column A is order received date for the customer in b column for product (in C column) with grid size (in d column) for qty (E column)
Column F is the stock available in that grid wise stock. i need to update G column on the qty which can be allocated to each of the customers on fifo basis.
Regards,
Pavan S
Need your help and assistance here. I am looking for powerquiery solution as i have data around 10 lakh plus rows to do the calculation for.
To explain about the data: on a daily basis we get the customer orders and we check if the stock is available we allocate them to those customers (we follow FIFO basis ) and bill them accordingly.
In the attached file column A is order received date for the customer in b column for product (in C column) with grid size (in d column) for qty (E column)
Column F is the stock available in that grid wise stock. i need to update G column on the qty which can be allocated to each of the customers on fifo basis.
Regards,
Pavan S