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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
arikofather
Helper I
Helper I

Merge Columns from two tables into same column in master table

 

I have two Tables:  Master and Mapping  as below:

 

Master    
 Company NameLocation 
 A Houston 
 B Dallas 
    
 D   
     
Mapping    
 Company NameLocation 
  Austin 
 D San Antonio 
     
Result    
Master     
 Company Name Location 
 A Houston 
 B Dallas 
  Austin 
 D San Antonio 
     

 

Using Query editor I wany to update Location column in table Master with Location in table Mapping where Company Name and Location exist in table Mapping.    Bear in mind there are hundreds of rows in my live tables.   These are just samples.

 

Is this possible in Query editor and how?

 

 

1 ACCEPTED SOLUTION
danextian
Super User
Super User

Hi @arikofather 

 

In the query editor merge Master with Mapping on Location columns from both.

danextian_0-1736831236337.png

After expanding add another column to coalesce between the two columns. The custom column will return the first non-null value so if you want Location from Mapping takes precedence, it should be the first column.

danextian_1-1736831273531.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

1 REPLY 1
danextian
Super User
Super User

Hi @arikofather 

 

In the query editor merge Master with Mapping on Location columns from both.

danextian_0-1736831236337.png

After expanding add another column to coalesce between the two columns. The custom column will return the first non-null value so if you want Location from Mapping takes precedence, it should be the first column.

danextian_1-1736831273531.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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