Forum Discussion
Combine two tables in a single table
Hi,
Want to combine below two tables into a single table (Final table)
table 1 table2
Column1 Column2 Column3 Column1 Column2 column3
a1 b1 c1 a1 d1 e1
a1 b2 c2 a1 d2 e2
a1 b2 c3 a1 d4 e3
a3 b3 c3 a3 d5 e4
a2 b4 c4 a2 d6 e5
a4 b4 c4 a4 d3 e6
a4 b5 c5 a4 d7 e7
a4 b5 c6 a4 d8 e8
FINAL TABLE
Column1 Column2 Column3 Column4 Column5
a1 b1 c1 d1 e1
a1 b2 c2 d2 e2
a1 b2 c3 d4 e3
a3 b3 c3 d5 e4
a2 b4 c4 d6 e5
a4 b4 c4 d3 e6
a4 b5 c5 d7 e7
a4 b5 c6 d8 e8
Regards,
Susritha
hi Anonymous
You could refer to this pbix file.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Regards,
Lin
2 Replies
- Greg_Deckler
Community Champion
Can you add an index to both columns? If you can, you could use Merge Query in Power Query or NATURALINNERJOIN in DAX.
- v-lili6-msft
Community Support
hi Anonymous
You could refer to this pbix file.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Regards,
Lin