Forum Discussion

Regular Visitor

2 years ago

Solved

Unable to implement IF and Text contains in m Query

HI,

I am trying to implement below M query, however gets the error message "Token 'Then' expected", can somebody help me here

if Text.Contains([Manager],"On Leave") AND [Grandparent]="" THEN "Error" ELSE"No Error"

collinq
2 years ago
Hi guna_knp ,

I beleive that the "then" and the "else" need to be lower case. Try that and let us know.
shafiz_p
2 years ago
guna_knp M code is case sensitive. For your case, you have to use all lower case for "AND", "THEN", "ELSE".

Check here for list of operators

Hope this help.

If this answered your question, please accept this as a solution!!

2 Replies

collinq
Super User
2 years ago
Hi guna_knp ,

I beleive that the "then" and the "else" need to be lower case. Try that and let us know.
shafiz_p
Super User
2 years ago
guna_knp M code is case sensitive. For your case, you have to use all lower case for "AND", "THEN", "ELSE".

Check here for list of operators

Hope this help.

If this answered your question, please accept this as a solution!!

Related content