Forum Discussion

TomSinAA's avatar
TomSinAA
Helper IV
2 years ago
Solved

Calculate column using if

I am trying to add a calculated column using this formula: If([Carrier]="B","V",if([Carrier]="B","V","E")).  However, Power BI indicates there is some type of error in the formula: 

 

Need Help
  • miTutorials's avatar
    miTutorials
    2 years ago

    The Formula is incorrect.. In Power Query it works differently, like below.

     

    =if([Column2]) = "Check"  then "Yes" else "No"

     

    Instead of adding a Calculated Column , add a Conditional column and add required clause.

     

     

1 Reply

  • miTutorials's avatar
    miTutorials
    Super User
    2 years ago

    The Formula is incorrect.. In Power Query it works differently, like below.

     

    =if([Column2]) = "Check"  then "Yes" else "No"

     

    Instead of adding a Calculated Column , add a Conditional column and add required clause.