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" ?...
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!

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!