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