Reply
CCAd
Frequent Visitor
Partially syndicated - Outbound

Combine two tables with similar column headings together

Hello everyone,

 

I have various tables loaded in my Power Bi file. I am trying to merge two tables, sales and leases, into one since they have same column headings. Both have a 'Listing ID' column which contains unique values. I tried the 'merge' within PQ but all it does is give me additional columns from the second table. I tried append also but that somehow nullifies the listing IDs of the second table.

 

Is there a way that I can do this? I did combine the two files in excel but for the sake of ensuring data update, I would prefer to do it from within power bi.

 

I am pasting snippets of both files below, if that helps. There are hundreds of other columns extending to the right in each table.

CCAd_0-1686117441031.png

 

CCAd_1-1686117503559.png

 

 

Thanks in advance

4 REPLIES 4
AlienSx
Super User
Super User

Syndicated - Outbound

hi @CCAd , Listing ID <> listing id

CCAd
Frequent Visitor

Syndicated - Outbound

sorry mate, didnt quite understand you. if you are referring that i match listing ID columns in each table with each other, i did that too (also renamed both so they are exactly the same). 

 

Can you dumb down the explanation for me please?

 

Thanks again

Syndicated - Outbound

PQ is case sensetive so "Listing ID" and "listing id" are not the same animals. 

CCAd
Frequent Visitor

Syndicated - Outbound

Great. Let me give it a shot.

 

Cheers

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)