Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Figured it out now - 

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