Forum Discussion
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 an error.
Provided is an image below to show exactly where the issue is
Can anyone help with this?
Austen229022 , Problem in row Two and 3
You are using [Column] >2 and <= 5
You need to use
[Column] >2 and [Column] <=5
3 Replies
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 <9If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
pls try this
= if [Assessment to Decision] <= 2 then "0 - 2 Working Days" else if [Assessment to Decision] <= 5 then "3-5 Working Days" else if [Assessment to Decision] <= 15 then "5 - 15 Working Days" else "15+ Working Days"
