Combining info from two tables to make one big table

[nhodges]

Hi I have two tables. I need to take the info from both tables and make one big table. No row should be a duplicate however if it is I do not want it to combine I just want both to be there. I saw a Union function in DAX but my rows are not in the same order and I also am not sure how to work that. Wondering if im on the right track. Could this also be done in a relationship? If so what woud the relationship cardinality be?

[ChielFaber · Accepted solution]

You can follow these steps and learn how to append two or more tables in powerquery

https://learn.microsoft.com/en-us/power-query/append-queries

[ChielFaber]

My advice would be to use the UI of powerquery. Just rearrange the columns in power query editor to ensure the columns of  both tables are in the same order. Then use the append fuction in the UI to get the result you want.

If you have duplicate rows you can also easily remove these through the powerquery UI with the remove duplicates function.

This would probably solve your problem in a few clicks

[nhodges]

Hi! Thank you, would you mind providing a screenshot, im not sure how use append function or to rearrange

[AlienSx]

Hello, @ChielFaber column names matter, not their order.