Excel Power Query-Merge two columns with distinct value

[aaleem]

HI,

i have two columns coming from different tables. both are for Invoice Date, i want to merge these two columns to a new column with distinct date, Example
Column1 Column 2 Custom Column (new)
Invoice_Date Invoice Date New Date
19/04/2021 19/04/2021 19/04/2021
27/01/2021 null 27/01/2021
17/11/2020 17/11/2020 17/11/2020

thanks
aleem

 

[Alex Blakenburg]

Unless I have misunderstood the requirement then a conditional column will do it.
Add Column > Conditional Column

I have done if not column is "not null" use that column otherwise use the other column.
You could of course reverse that with is "is null" use "other" column else use this column.

 

[aaleem]

Thanks, Alex, this is exactly what I was looking for. Thanks for your help

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.