need help with IF function

Copper Contributor

Hello, 

Here is what I am trying to achieve. In column G called PO exist I need yes or no. I want function to look if SKU is equal to Re-order "Yes" then look at PO QTY if there is any qty greater than 1 return Yes or NO. 

I want to use this function in Powerbi table. 

 

Atinder23_0-1677698340865.png

 

Thank you!

 

3 Replies

@Atinder23 

What do you want to return if Re-order is "No"?

@Hans Vogelaar 

If Re-order is blank. I want return it blank or no.

@Atinder23 

=IF(AND(E2="Yes",F2>0),"Yes","No")