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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
botjeff
Regular Visitor

Need help in joining two tables using (JOIN/APPEND/MERGE)

I do not know to use append or merge or join in this situation.
 
Let me explain my situation first.
I have two separate data sheet. Let's call it data A and data B. Data A consists of data related to Parent Cust No with some other columns that may or may not exist in Data B. And Data B consists of data related to MKS Parent ID might have something Data A doesn't have. They both have some similarities.

Dashboard A using Data A
 
botjeff_1-1708583165504.png

 Dashboard B using Data B
 botjeff_2-1708583201901.png

 

 
Parent Cust No (from Data A) literally mean the same thing as MKS Parent ID (from Data B). They both are describing the name of an outlet. I'm trying to match them both as a single unit so that I can use slicer that can easily filter both of the table in the dashboard while both showing different column data at the same time.
 
 
Extra information : From Dashboard B, if we sum up Sum of OVD 1-7, until the end of the columns which is the Sum of OVD>365 for a specific Parent Cust No/MKS Parent ID, they will equal to the amount of Sum of Cust O/S Balance in (Dashboard A). So to give an idea, they both are referring to the same data, just showing it a different way and might have extra information that might not exist in other datasheet. Though, I'm hesistant to just union them both, to avoid any mismatched data.
 
Any solutions are welcomed ! I'd really appreciate your help. Thank you.
3 REPLIES 3
lbendlin
Super User
Super User

Change the name of the first column so it matches exactly between the two tables, then in Power Query do a Table.Combine (or & ) on Data A and Data B.  Power Query will merge matching columns and add the extra columns from both sides.

Hi, this sounds like a no brainer. Thanks, but is there an option where PowerQuery can automatically change the column name, and merge them together rather than changing them in the Excel and merge them. The dashboard need to be updated daily with new files, and I was planning for it using date extraction, and include/exclude parameters. Thank you.

Not sure what you mean by "automatically" but you could do that renaming as part of the load process. Be very aware that Power Query is case sensitive.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors