Substract based on criteria

[mb0307]

Hi,

I have a Purchase Order (PO) data below:

If Movement Type is 102 then I want to find 101 value with same Batch and Quantity (in Confirmed Qty and Posting Qty columns).  Substract Qty in Confirmed and Posting Qty column.

So the result and sum should look like this:

Thanks in advance.

[v-lionel-msft · Accepted solution]

Hi @mb0307 ,

Try this.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Why would that be? Are there any user interactions that could influence the computation?

[mb0307]

Not really - I am little more comfortable with DAX than M.  But any solution as long as I can get a solution please.  

[lbendlin]

Would you like the result in Power Query or in DAX?

[mb0307]

@lbendlin DAX please

[lbendlin]

please re-post. images are not showing.

[mb0307]

@lbendlin  please check now.