Power Query Custom Column: If date is null, calculate from another date column

I am attempting to write a formula in Power Query to add a new date column. The formula should add 90 days to a date in date column 1. if cell is null in date column 1 add 90 days to the date in date column 2. I have pasted me code below

= Table.AddColumn(#"Changed Type3", "90 Days", each if [#"Change Date (FT)"] = null then Date.AddDays([#"FT-Date"], 90) else Date.AddDays([#"Change Date (FT)"], 90)


I am receiving a syntax error: "Token RightParen expected."
Apologies if this has already been answered.

Thank you in advance.

Looks like you are missing the final closing parenthesis

in your syntax the final ) corresponds to .AddDays function. Add another to close off .AddColumn

Thanks Andy. I closed off the Add.Column but I am still receiving the same error. Just to double check, what I am trying to do is possible, correct?

Edit: My mistake. I"m having an issue with (#"Changed Type3", call. I am editing the formula and it must be an issue of action order?

This syntax works for me.

Please Login or Register  to view this content.

I see that "Changed Type" is the name of a previous step within the editor. So as long as your match it should be okay