New Column with IF Statement with multiple conditions

[Anonymous]

Hello,

I would like to create a new column (not in a query) so that return a value of "ERROR" if values in either "WorksetName" and "TypeWorksetName" do not start with "Links CAD".

This is not working

FileType = IF(

OR(

ISERROR(SEARCH("Links CAD", 'LinkAndImportInstances2-4'[WorksetName])),

ISERROR(SEARCH("Links CAD", 'LinkAndImportInstances2-4'[TypeWorksetName]))

)

"Wrong Workset",

"OK"

)

Thank you

[ChrisMendoza · Accepted solution]

@Anonymous -

Hard to tell without sample data. I gave it a shot anyways.

FileType using SEARCH = 
IF (
    OR (
        SEARCH ( "Links CAD", 'LinkAndImportInstances2-4'[WorksetName], 1, 0 ) = 1,
        SEARCH ( "Links CAD", 'LinkAndImportInstances2-4'[TypeWorksetName], 1, 0 ) = 1
    ),
    "OK",
    "Wrong Workset"
)

SEARCH ( ) returns the starting position of the text -> '0Links CAD" returns 2