Reply
cel
Helper I
Helper I
Partially syndicated - Outbound

Token then expected error

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? 

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Syndicated - Outbound

Hi @cel ,

 

Try writing all the "AND"s in lowercase as "and".

M language is entirely case-sensitive, so this is probably the issue.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
cel
Helper I
Helper I

Syndicated - Outbound

Thanks @BA_Pete ! That solved my issue 🙂

BA_Pete
Super User
Super User

Syndicated - Outbound

Hi @cel ,

 

Try writing all the "AND"s in lowercase as "and".

M language is entirely case-sensitive, so this is probably the issue.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)