Combine data from 2 tables into a single column

[vanessa]

I have 2 tables:

Table1:                Table2:

COL1                   COL2

A                           1

B                           2

C                           3

I want to create a new table as below:

Table3:

A

B

C

1

2

3

Is there any DAX function ?

[amitchandak · Accepted solution]

@vanessa , Try new table like

new table =

Union (all(Table1[col1]),all(Table2[col2]))

[vanessa]

Thanks @amitchandak  that worked.