Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Combined multiple if and formulas

The formula does not work, it return "missing token else"   if [Quantità 2022]>0 and [2021.Quantità]=0 then "Entrati" if [Quantità 2022]=0 and [2021.Quantità]>0 then "Usciti" if [Quantità 2022]=[...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi Anonymous 

     

    The syntax for if then else in Power Query is

     

    if Test1 then Result1

else if Test2 then Result 2

else if Test3 then Result3

else DefaultResult

     

    So you are missing the else statements between each if like so 

     

    if [Quantità 2022]>0 and [2021.Quantità]=0 then "Entrati"

else if [Quantità 2022]=0 and [2021.Quantità]>0 then "Usciti"

else if ........

     

    regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
3 years ago

Hi Anonymous 

 

The syntax for if then else in Power Query is

 

if Test1 then Result1

else if Test2 then Result 2

else if Test3 then Result3

else DefaultResult

 

So you are missing the else statements between each if like so 

 

if [Quantità 2022]>0 and [2021.Quantità]=0 then "Entrati"

else if [Quantità 2022]=0 and [2021.Quantità]>0 then "Usciti"

else if ........

 

regards

 

Phil