How to get distinct values when two tables are joined using Union?

[Anonymous]

Hi,

I Have two tables, where table A has unique values and tables B(dynamically updated) will always contain a few records from table A.  Table A

Table B

When I do UNION, I get duplicate rows. 

I have also tried using 

Union = DISTINCT(UNION(VALUES('Table 2'[Date]),VALUES('Table 1'[Date])))  But I can only pull single column with Distinct values. 

I need all the columns Dates, Open, High, Low etc. without duplicate rows. 

Can anyone help me with this? 

[amitchandak · Accepted solution]

@Anonymous 

This is because open High, low values has some diff.

Use Summarize and take min and max of that

Try like

summarize(UNION(VALUES('Table 2'),VALUES('Table 1')),[Date],"Open",max([Open]),"Low",min([Low]),"High",max([High]))

[MattAllington]

UNION in DAX is the same as UNIONALL in SQL. Wrap the whole thing inside DISTINCT()