Forum Discussion

Libbya's avatar
Libbya
New Member
4 years ago
Solved

IF Statement help

Hi I have created a new column and now trying to create the following If statement to return either 1,2 or 3 in the new column but get a syntax error message. Any suggestions?     Qtr1 Results = I...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Libbya 

    pls try this

    Qtr1 Results = IF('Tier 2 FY23'[Qtr1]='Tier 2 FY23'[Green],"1",If('Tier 2 FY23'[Qtr1]='Tier 2 FY23'[Amber],"2",If('Tier 2 FY23'[Qtr1]='Tier 2 FY23'[Red],"3")))

     

    the last equal sign is wrong, should be comma.

     

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

Libbya 

pls try this

Qtr1 Results = IF('Tier 2 FY23'[Qtr1]='Tier 2 FY23'[Green],"1",If('Tier 2 FY23'[Qtr1]='Tier 2 FY23'[Amber],"2",If('Tier 2 FY23'[Qtr1]='Tier 2 FY23'[Red],"3")))

 

the last equal sign is wrong, should be comma.