Expression.Error: 1 arguments were passed to a function which expects between 2 and 3. Details:

[Jitmondo]

Hi All 

I am getting this error when making a custom column the syntax is accepted and closes, when I look at the column it has errors which reference the error message in the subject above.

Using custom column in PQE, I entered = Table.AddColumn(#"Added Campaign Class", "Custom", each if (not Text.Contains([Name], "Europe") and Text.Contains([Name])=" uk car sale") then " uk car sale" else "no")

I want a column that will tell me where the name is not europe but contains uk car sale then label this as uk car sale

any ideas on what I am doing wrong here ?

[Jitmondo]

Thanks Antriksh this seems to have worked !

[AntrikshSharma · Accepted solution]

@Jitmondo Text.Contains([Name])=" uk car sale") should be 

Text.Contains ( [Name], "uk car sale" )