Token EOF expected error

theja gamage 21 Reputation points
2022-10-21T10:04:02.6+00:00

I tried simple nested query in power query editor,

it gives Token EOF expected error. what is the reason

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,161 questions
0 comments No comments
{count} votes

Accepted answer
  1. Pavlovic, Dusan 111 Reputation points
    2022-10-21T10:19:22.417+00:00

    Hi @theja gamage ,
    The Power Query IF and IF ELSE statements are case-sensitive and they require lower-case. Change IF to if.

    7 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.