need to copy distinct rows from one table into another

[Anonymous]

I have a column which has duplicate date entries like

Date                    Output Column in another table 

2/1/2019               2/1/2019

2/1/2019               2/2/2019

2/2/2019               2/3/2019

2/2/2019

2/3/2019

2/3/2019

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

For your requirement, you could create the calculated table with the formulas below.

Table 2 = VALUES('Table'[Date])
OR
Table 3 = SUMMARIZE('Table','Table'[Date])

Here is the output.

Best Regards,

Cherry