Create Conditional column based on several conditions

[acg]

How do I write a conditional statement that creates a new variable 'procedures to verify new customer 0/1' based on the condition that 'v_QNA'[Answer] = "Yes"   and 'v_QNA'[Question Code]= " Q0056" ?

It is probably easier to simply create a new conditional column in the Transform Tab, but I think it only works with 1 condition only. 

Any suggestions?

Why the below does not work? 

procedures to verify new customer 0/1 =

IF

(

'v_QNA'[Answer] = "Yes" && 'v_QNA'[Question Code]= " Q0056",1,0

)

[shreyamukkawar · Accepted solution]

Hi @acg ,

1. Create new column as

procedures to verify new customer 0/1 = IF(Sheet1[QNA]="yes" && Sheet1[QNA code]="Q0056",1,0)  

output:

Best Regards,
Shreya

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!