Help with correcting conditional column in Power Query

[Anonymous]

Hi

Can someone help me correct this:

= Table.AddColumn(#"Changed Type1", "Charge", if [Freight_Kind] = "ABC" and [Category] = "BBC" or "BBD" then 10.5 else 0)

error Im getting is:

Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?

Thanks so much!

[Jakinta]

= Table.AddColumn(#"Changed Type1", "Charge", if [Freight_Kind] = "ABC" and [Category] = "BBC" or [Category]="BBD" then 10.5 else 0)

[Anonymous]

Thanks for your quick response but Im still getting the same error?

[Jakinta · Accepted solution]

Then you should provide a sample...

or...

= Table.AddColumn(#"Changed Type1", "Charge", each if [Freight_Kind]="ABC" and ([Category]="BBC"or [Category]="BBD") then 10.5 else 0)

And you can play with parenthesis...

[Anonymous]

Thats done it, thanks so much!