Forum Discussion

Austen229022's avatar
Austen229022
Icon for Helper II rankHelper II
2 years ago
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...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    2 years ago

    Austen229022 , Problem in row Two and 3

    You are using  [Column] >2 and <= 5

     

    You need to use

    [Column] >2 and [Column] <=5

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

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"