Calculate column using if

[TomSinAA]

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: 

[miTutorials · Accepted solution]

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.