Question: order fulfillment based on running total

[SCD]

Hi guys, 

I have 1 year experience with PowerBI and this is my first post on the forum. Sorry if I did not explain the question clearly or there is already an answer. 

The problem is, the business requires to cancel some customer orders, based on material available quantity. 

    - Customer orders are based on Material / plant, and will be fulfilled by Order Sequence. 

    - If the Available Quantity is > Order Quantity, then this line can be fulfilled. 

    - If the Available Quantity < Order Quantity, then this line needs to be cancelled

    - repeat the process for all orders. 

Below is an example. 

• first line: no issue
• 3rd line: cannot fulfill
• 4th line: no issue
• ...

Is it possible to write an DAX expression, to determine which order should be fulfilled or cancelled? 

Material	Plant	Order Sequence	Order Qty	Available Qty	Balance After Order	Order Fulfill?
A	X	1	200	1000	800	Y
A	X	2	300	1000	500	Y
A	X	3	900	1000	500	N
A	X	4	100	1000	400	Y
A	X	5	300	1000	100	Y
A	X	6	500	1000	100	N
A	X	7	100	1000	0	Y
A	X	8	200	1000	0	N

[sritha55]

Hi @SCD,

Hope you are doing good. I have got the exact requirement. could you please share the solution if you have achieved it. It would be very helpful.

Thanks,

sritha

[davehus]

Hi @SCD ,

Is this your current table layout or the desired output?

[SCD]

Hi Davehus, 

Thank you for the reply. 

Material, Plant, Order Sequence, Order Qty and Available Qty is my current table layout. 

I wish to have the last 2 columns as output.