topic Inconsistent Validation for Syntax in DAX Commands and Tips

Inconsistent Validation for Syntax

Anonymous — Thu, 04 Nov 2021 16:53:36 GMT

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?

Re: Inconsistent Validation for Syntax

Greg_Deckler — Thu, 04 Nov 2021 17:10:56 GMT

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.

Re: Inconsistent Validation for Syntax

Anonymous — Thu, 04 Nov 2021 18:46:23 GMT

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