Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Jitmondo
Helper III
Helper III

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

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 ?

1 ACCEPTED SOLUTION
AntrikshSharma
Community Champion
Community Champion

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

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

 

View solution in original post

2 REPLIES 2
Jitmondo
Helper III
Helper III

Thanks Antriksh this seems to have worked !

AntrikshSharma
Community Champion
Community Champion

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

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

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Top Solution Authors
Top Kudoed Authors