Exceptions by customer and quantity

[ALN]

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.

[ALN]

Company 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

[Ritaf1983]

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/1447523