cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chademe Frequent Visitor
Frequent Visitor

Problem using an if statement with a column name with a "/" in it

I have a line like this in my query:

 

= Table.ReplaceValue(#"Replaced Value11", each [CBT], each if [Customer Name/Customer ID]= "Sample Name" then "Something" else [CBT],Replacer.ReplaceValue,{"CBT"} )

 

and it generates an error in the if statement pointing to the text prior to the / saying Expression.SyntaxError: Invalid identifier.

 

However, if I change the column reference in the if statement to a column name without a / in it, it works fine.  Can someone explain why it doesn't like the / in the column name?  Will a / in the column name cause problems in other areas?

 

thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

Re: Problem using an if statement with a column name with a "/" in it

Just a Syntax thing to handle special characters in Column Name. Ideally we shall avoid special characters in Name if not necessary.


View solution in original post

3 REPLIES 3
Highlighted
Super User I
Super User I

Re: Problem using an if statement with a column name with a "/" in it

Try below using #"Customer Name/Customer ID". 

 

= Table.ReplaceValue(#"Changed Type", each [CBT], each if [#"Customer Name/Customer ID"]= "Sample Name" then "Something" else [CBT],Replacer.ReplaceValue,{"CBT"} )

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

 

chademe Frequent Visitor
Frequent Visitor

Re: Problem using an if statement with a column name with a "/" in it

Thanks @AnkitBI  for the tip.  Do you know why the behavior in the if statement is different for column names with a / and those without?  Should I avoid using / in my column names?

 

thanks,

Chad

Super User I
Super User I

Re: Problem using an if statement with a column name with a "/" in it

Just a Syntax thing to handle special characters in Column Name. Ideally we shall avoid special characters in Name if not necessary.


View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors