Forum Discussion
Substract based on criteria
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.
Hi mb0307 ,
Try this.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
Hi mb0307 ,
Try this.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
please re-post. images are not showing.
Would you like the result in Power Query or in DAX?
Why would that be? Are there any user interactions that could influence the computation?
Not really - I am little more comfortable with DAX than M. But any solution as long as I can get a solution please.
