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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Conditional Merge with power query

Hi Everyone,

 

Wanted just to ask to the community here, if you think is possible to make a conditional merging with 2 lookup tables.

Let's say I have a data table and in this table a column (Address) with a list of addresses, but no country, only city, so I want to add a second column with the country.  This information is available to me but in 2 separated lookup tables in one some addresses and in another other addresses, in the lookup tables, each address has its country in a separate column, and, I want to program the M code so that if the address of data table matches the address of lookup table1, then it gives me the country from lookup table 1, if there is no match, the code sees if there is the match in lookup table 2, if yes, then it gives me the country from lookup table 2, if also here no match for my address, then, either it leaves it blank or it writes a simple "-".

 

Was wondering what you think about it/if anyone thinks it is doable? 

 

Thanks!

Stefano

1 REPLY 1
AlexisOlson
Super User
Super User

You can do both merges and then coalesce the two country columns into a single column.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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