How to union two date columns into one

Hi,

starting from this

insert a step after

and modify your step this way

=Table.ToColumns( #"Changed Type")

retransform to table

and expand to new rows

then remove duplicates

change type to date

 and sort ascending

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!

you can use a conditional column

Hi -

Here is a simple solution using M-code:

This assumes you have a table represented by a query called "Dates", it has 2 columns - Date1 and Date2:

let
Col1 = Dates[Date1], //  Creates a column object from Date1 of the table Dates
Col2 = Dates[Date2], // Creates a column object from Date2 of the table Dates
NewTable1 = Table.FromColumns({Col1}), // Creates a new table made up only of column 1
NewTable2 = Table.FromColumns({Col2}), // Creates a new table made up only of column 2
NewTable3 = Table.Combine({NewTable1,NewTable2}) // Uses the Table.Combine function - merges the 2 tables

in
NewTable3 // Returns the new table

Hope this helps!

Peter