Remove Duplicated Rows in a table

[TomLU123]

Hi Experts, 

I am creating a new table that collect all the dates of two other tables by using following formular.

Date Table =
UNION (
SELECTCOLUMNS('Overall Result',"Date",'Overall Result'[Date]),
SELECTCOLUMNS('Hiring Manager List',"Date",'Hiring Manager List'[Created]))

Is it possible to add some formular to remvoe duplicated date in this new table at the same time?

Many thanks!

Best regards,

Tom 

[donsvensen · Accepted solution]

Hi Tom,

You could use DISTINCT 

DISTINCT(
UNION (
SELECTCOLUMNS('Overall Result',"Date",'Overall Result'[Date]),
SELECTCOLUMNS('Hiring Manager List',"Date",'Hiring Manager List'[Created]))
)

or consider doing the table using Power Query

/Erik