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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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
Super User
Super User

@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
Super User
Super User

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

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

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors