Inconsistent Validation for Syntax

[Anonymous]

I added a custom column using the following:

if SEARCH( "FY",[Deal ID],1,0)>0 then [Deal ID]
else [Sales Order]

I get confirmation of no syntax errors, but when I click 'OK' to exit out of the custom column screen, the main screen then throws the following:

Expression.Error: The name 'SEARCH' wasn't recognized. Make sure it's spelled correctly.

Can you please help with what I am doing incorrectly?

[Anonymous]

Thank you! This was in Power Query Editor, so I was able to use Text. function to get what I needed.

[Greg_Deckler · Accepted solution]

@Anonymous If this is DAX then it should be:

if(SEARCH( "FY",[Deal ID],1,0)>0, [Deal ID], [Sales Order])

If this is Power Query Editor then your if then else syntax is correct but there is no SEARCH function in Power Query it is something like Text.Contains.