Forum Discussion
Milagros
4 years agoHelper I
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.