If Function in PowerBI Query Editor

[justin22pogi]

Hi All,

I want to add a column in my existing table in Power BI Query Editor using add custom column. The formula that I want to use is that:

If column A = "#" then value in column B else column A.

I cannot construct the formula since I am receiving a Token Literal expected. Thanks in advance!

[v-piga-msft]

Hi  @justin22pogi,

Have you solved your problem with the reply provided by @Barnee?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some screenshots to specify your problem.

For further, you could have a view of the syntax of IF FUNCTION in Power Query.

Best Regards,

Cherry

[Barnee · Accepted solution]

Hi,

you may want to check if you wrote the "if" function in the rigth syntax since a little mistype could possibly couse error.
I didn't get an error with the following formula following yours.

if [column a] = "#" then [column a] else [column b]