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.

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Libbya , try like

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")))

 

 

Or Try Switch

 

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