Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
I am experiencing a token then expected error for the following code with the first AND underlined in red:
if [rev] <1 then "Stopped"
else if [rev] >= 1 AND [rev] <= 100000 then "Below $100K"
else if [rev] > 100000 AND [rev] <= 500000 then "Between $100K and $500K"
else if [rev] > 500000 AND [rev] <= 1000000 then "Between $500K and $1M"
else if [rev] > 1000000 AND [rev] <= 5000000 then "Between $1M and $5M"
else "More than $5M"
how can i get rid of this error?
Solved! Go to Solution.
Hi @Anonymous ,
Try writing all the "AND"s in lowercase as "and".
M language is entirely case-sensitive, so this is probably the issue.
Pete
Proud to be a Datanaut!
Hi @Anonymous ,
Try writing all the "AND"s in lowercase as "and".
M language is entirely case-sensitive, so this is probably the issue.
Pete
Proud to be a Datanaut!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |