Forum Discussion

acg's avatar
acg
Resolver I
3 years ago
Solved

Create Conditional column based on several conditions

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
)
 
 
 
DAX
  • Anonymous's avatar
    Anonymous
    3 years ago

    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!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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!