Forum Discussion
Exceptions by customer and quantity
I am trying to build a formula to give me yes or no. If a customer orders less than minimum order quantity but approved for an exception then it gives yes. If not approved for an exception then no.
2 Replies
Hi ALN
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Company Name Item - UPC Item Number SalesOp Report Name Status Gordon Mars 0001 FR0007 Candy Approved Massive Corp 0002 FR0001 Ice Cream Approved Capital Dynamic 0001 FR0007 Candy Approved If our MOQ is 24cs and Gordon Mars only ordered 12cs, but since they are on our exception list it would say YES. Example Below:
Ship Date Requested Delivery Date Company Name Customer PO# Item Reporting Catergory Cases Per Layer Cases Per Pallet MOQ Item Multiple Item - UPC Original Order Qty MOQ MET Exception 11/20/2023 11/23/2023 Gordon Mars 1234 Candy 12 60 60 60 0001 12 NO Yes
