I want to merge two tables with duplicates

[HJK]

Hi

I want to duplicate two tables and merge them using DAX.

How can i do that?

please see the screenshot below

1. Table A

2. Table B

3. Table C (Merge)

[Jihwan_Kim · Accepted solution]

Hi,

Please check the picture down below, and the attached pbix file.

It is for creating a new table.

[HJK]

Thank you for your help.

1 more question.

How can I get only specific columns?

[Jihwan_Kim]

Hi, 

thank you for your feedback.

In case you want to select some columns, please check the below picture and the attached pbix file.

TableC =
SELECTCOLUMNS ( CROSSJOIN ( TableA, TableB ), "A", TableA[A] )