custom column

[Anonymous]

Thanks in advance for looking. 

I need help creating a custom column. 

In short, I need to create a column that gives me Date2 however IF Null it gives me Date1. Essentially merging date 1 into the null values of Date 2

[Anonymous · Accepted solution]

Figured it out now - 

= Table.AddColumn(#"Renamed Columns1", "Custom", each if [Date2] = null then [Date1] else [Date2])