AND-OR on New Column

[ezequiel]

Hi

I'm trying to add a new column and using the following definition trying to combine OR/AND

= Table.AddColumn(#"Added Conditional Column1", "Compliance", each if (([Request Status] = "Pending" or [Request Status] = "Assigned to" or [Request Status] = "Processing" or [Request Status] = "Pending Approval" or [Request Status] = "On Hold" or [Request Status] = "Pending DocuSign" or [Request Status] = "Pending Recipient Information") and [Compliant Request]="NO") then "NO" else "YES")

but doesn't seems to work. I have on the column "Request Status" the value the value "Assigned to" and on the column "Compliant Requests" the value "NO" and I'm getting "YES" as result, when the expected result should be "NO".

Any clue on this?

thanks,

[v-yuta-msft]

Hi ezequiel ,

Please check if there're some unprintable characters in your column. Use trim to remove those character and try again.

Regards,

Jimmy Tao

[ezequiel]

Hi Jimmy...I checked and there are not unprintable chars. Any other suggestion? Do you see any issue on the logic I built?

Thanks,

[quentin_vigne · Accepted solution]

Hello @ezequiel

Not sure about the syntax of your AND / OR

The correct syntax is : AND(X;Y) / OR (X;Y) 

Maybe try to add a new column and then type in : 

Column = IF(AND([Compliant Request]="NO";OR([Request Status] = "Pending";OR([Request Status] = "Assigned to";OR([Request Status] = "Processing";OR([Request Status] = "Pending Approval";OR([Request Status] = "On Hold";OR([Request Status] = "Pending DocuSign";[Request Status] = "Pending Recipient Information")))))));"NO";"YES")

Not sure about the result matching what you are looking for (we need more details to help you)

EDITED 16h24