Conditional column need IF AND

[KristofferAJ]

Hi 
I have a powerquery function adding a new column with some conditions:

= Table.AddColumn(#"Changed Type2", "(C) Enrolled", each if [#"# Enrolled - Copy"] = "NULL" then 0 else if [#"# Enrolled - Copy"] = "TERM" then 0 else if [#"# Enrolled - Copy"] = "DATA" then 0 else if [#"# Enrolled - Copy"] = "SI" then 0 else [#"# Enrolled - Copy"])

I would like to build another condition into this:
IF [Duration COLUMN] is not blank then return 0 in the (C) Enrolled column

I have tried something like this, but can't get it to work

= Table.AddColumn(#"Changed Type2", "(C) Enrolled", each if [#"# Enrolled - Copy"] = "NULL" then 0
else if [#"# Enrolled - Copy"] = "TERM" then 0
else if [#"# Enrolled - Copy"] = "DATA" then 0
else if [#"# Enrolled - Copy"] = "SI" then 0
else if [#"# Enrolled - Copy"] = null AND [Duration COLUMN] IS NOT BLANK then =0
else [#"# Enrolled - Copy"])

[AlexisOlson · Accepted solution]

If by "blank" you mean null, then try updating the line to

else if [#"# Enrolled - Copy"] = null and [Duration COLUMN] <> null then 0

Note that M is case-sensitive so you need to use "and" instead of "AND".

If [Duration COLUMN] has different types of blanks like the empty string "" or white space " ", then use those instead of null above.