Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
Just a Syntax thing to handle special characters in Column Name. Ideally we shall avoid special characters in Name if not necessary.
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.
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
Just a Syntax thing to handle special characters in Column Name. Ideally we shall avoid special characters in Name if not necessary.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.