Can't make IF statement work in Power BI

[AnjaD]

I am trying to create a new column using an IF statement. If the column 'Survey Type' = AML Quantitative then return with the value in column 'Status'. In the status column there are various answers such as 'Completed', 'Not Started' or 'Compliance Review 4 in progress' etc. That is the value I would like to return. Below is the if statement with no syntax errors.

When hit 'Ok' it says: 'Expression.Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly.' When I change IF to if I get the following message:

I remove the ) but it doesn't change anything. I am new to this so any help would be appreciated.

[AnjaD]

@mlsx4 thank you very much. I figured it out. You saved my day!!

IF [Survey Type]="AML Quantitative" then [Status] else ""

[mlsx4]

You're welcome! I'm glad it works now

[AnjaD]

I tried that and now I get this error:

Not sure how to fix that.

[mlsx4 · Accepted solution]

Hi @AnjaD 

In M, I think you need to use if conditional in this way:

IF <condition> then <ResultTrue> else <ReturnFalse>

So if I'm not wrong, you should write:

IF [Survey Type]="AML Quantitative" then [Status]

Anyway, taking into account the error given, the problem is you are missing a ")", so you need to add it, not to remove it