Expression Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly.

[EashwarBalaji]

I have to create a custom column "Lift/Escalator" which has the value "Lift" or "Escalator" based on another column, "lift_list".

That is If [lift_list] is not null, then Lift/Escalator should have "Lift", otherwise "Escalator"

I tried the following two formulae

1. = Table.AddColumn(#"Renamed Columns", "Lift/Escalator", each IF( ISNOTBLANK([lift_list]) , "Lift" , "Escalator" ))

2. = Table.AddColumn(#"Renamed Columns", "Lift/Escalator", each IF [lift_list] <> null , "Lift" , "Escalator" )

I got this error for both:

Can you please help me solving this. Thanks in advance!

[johnt75 · Accepted solution]

Power Query is case sensitive, use the second version of your code but use if instead of IF

[EashwarBalaji]

Thanks. It worked