Forum Discussion

hongho2's avatar
hongho2
Frequent Visitor
2 years ago

New column

Hi, I am attempting to add a new column with the syntax  NewDate =IF(ISBLANK([#"Backlog[Ship Date]"]), [#"Delivery Date[Delivery Date]"], [#"Backlog[Ship Date]"]) It shows no syntax error  from sec...
Need Help
mlsx4's avatar
mlsx4
Memorable Member
2 years ago

Hi hongho2 

 

You should do it like this: 

NewDate = each if[#"Backlog[Ship Date]"]=null then [#"Delivery Date[Delivery Date]"] else [#"Backlog[Ship Date]"]