Forum Discussion
Anonymous
6 years agoNot applicable
custom column
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
- Anonymous6 years ago
Figured it out now -
= Table.AddColumn(#"Renamed Columns1", "Custom", each if [Date2] = null then [Date1] else [Date2])
1 Reply
- AnonymousNot applicable
Figured it out now -
= Table.AddColumn(#"Renamed Columns1", "Custom", each if [Date2] = null then [Date1] else [Date2])