Forum Discussion
Responsive ResidentSubstract 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
v-lionel-msftCommunity Support
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.
- lbendlin
Super User
please re-post. images are not showing.
- lbendlin
Would you like the result in Power Query or in DAX?
- lbendlin
Why would that be? Are there any user interactions that could influence the computation?
mb0307Not really - I am little more comfortable with DAX than M. But any solution as long as I can get a solution please.
