topic Re: I want to merge two tables with duplicates in DAX Commands and Tips

I want to merge two tables with duplicates

HJK — Tue, 08 Nov 2022 06:45:04 GMT

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 — Tue, 08 Nov 2022 06:52:25 GMT

Hi,

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

It is for creating a new table.

HJK — Tue, 08 Nov 2022 07:58:28 GMT

Thank you for your help.

1 more question.

How can I get only specific columns?

Jihwan_Kim — Tue, 08 Nov 2022 09:46:50 GMT

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] )