issue in IF statement | expression.error

[Anonymous]

Hi,

Please, I need help to solve the problem below

Thank you 🙂

[AlB · Accepted solution]

Hi @Anonymous 

Just drop the parentheses: "(" and ")" and don't capitalize the if

= if [Exectuted percentage] = 100 then "Completed" else "Null"

you can also use null instead of the text "Null"

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Just a couple of notes, M is case sensitive and the if statement must be in lower case, so you must write if rather than IF

You can set the result of the if to be the actual value null rather than the text string "Null" e.g.

= if [Executed Percentage]=100 then "Completed" else null

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[AlB · Accepted solution]

Hi @Anonymous 

Just drop the parentheses: "(" and ")" and don't capitalize the if

= if [Exectuted percentage] = 100 then "Completed" else "Null"

you can also use null instead of the text "Null"

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers