Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
nhodges
Helper I
Helper I

Combining info from two tables to make one big table

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?

1 ACCEPTED SOLUTION
ChielFaber
Super User
Super User

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

View solution in original post

4 REPLIES 4
ChielFaber
Super User
Super User

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
Super User
Super User

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

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

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

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors