Unable to implement IF and Text contains in m Query

[guna_knp]

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 · Accepted solution]

Hi @guna_knp ,

I beleive that the "then" and the "else" need to be lower case.  Try that and let us know.

[shafiz_p · Accepted solution]

@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!!

[collinq · Accepted solution]

Hi @guna_knp ,

I beleive that the "then" and the "else" need to be lower case.  Try that and let us know.