IF and statement

[AngelA05]

Hi,

I get the following error message i.e Expression.Error: The name 'LEN' wasn't recognized. Make sure it's spelled correctly.

= Table.AddColumn(#"Added Conditional Column", "SAP2", each if[ISO COUNTRY CODE]="ES" and LEN([ISO COUNTRY CODE])=9 then "TRUE" else "FALSE")

This is what I put in my custome box 

if[ISO COUNTRY CODE]="ES" and LEN([ISO COUNTRY CODE])=9 then "TRUE" else "FALSE"

Im strugglingcan anyone help.

Thanks,

AngelA

[ChrisMendoza · Accepted solution]

@AngelA05 -

Looks like you're in the Power Query Editor. You should probably use Text.Length( ).

[AngelA05]

Perfect it works.

Thankyou