Forum Discussion
Solved
Power Query Literal Token Expected
I am trying to set up a simple IF AND statement to check within ranges to the provide a range category, though I am having an issue with a Literal Token Expected error on something that shouldnt be a...
Austen229022 , Problem in row Two and 3
You are using [Column] >2 and <= 5
You need to use
[Column] >2 and [Column] <=5
Hi Austen229022
When you writing and/ or statements in PQ
You need to repeat a column name:
if a>5 and a<9...
not
if a>5 and <9
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly