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 col...
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]

     

     

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]