Forum Discussion

justin22pogi's avatar
justin22pogi
Regular Visitor
8 years ago
Solved

If Function in PowerBI Query Editor

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!

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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]

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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]

     

     

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi  justin22pogi,

     

    Have you solved your problem with the reply provided by Anonymous?

     

    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