Forum Discussion

Milagros's avatar
Milagros
Helper I
4 years ago
Solved

Token Else

Hi there, I am trying to enter create a Custom Column in Power Query, but I am getting a 'Token else expected' error message.  When I select show error it takes me to the very end of the formula. The formula is meant to identify whether a result is on target, below target or within a set margin of the target. 

 

if [Target]= null or [Result]= null then null
else if [Polarity]="Higher is better" and [Result]>=[Target] then 1
else if "Higher is better" [Result]>=([Target]*0.95) then 0
else if "Higher is better" then -1
else if [Polarity]="Lower is better" and [Result]<=[Target] then 1 else if "Higher is better" [Result]<=([Target]*0.95) then 0
else if "Higher is better" then -1

  • Your 3rd and 4th line of code are missing testing criteria.

2 Replies

  • Jakinta's avatar
    Jakinta
    Solution Sage

    Your 3rd and 4th line of code are missing testing criteria.