Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Merge query based on multi columns

I am looking to merge a table but i am trying to merge based on 2 parametars so for example if i have a column 1 to 10 then another column which is user bandings i need to be able to merge base on column 1 but also to furth filter the dataset to column 2. Is there an easy was to do this?

Super User V
Super User V

Re: Merge query based on multi columns

Hi @dataman123 ,


When you merge two tables you can make it by more than one column you just need to be carefull on the order you select the columns.


Two things to be carefull:

  • Use CTRL to select your columns
  • Be sure you match the numbers of the columns on both tables



Small number highligted appears after selection of the columns with control and indicates the order of the columns if you change it you will get different results see image below:




First example no matches second example since the first column don't have the same type it doesn't allow the match,.






Miguel Félix

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

Proud to be a Super User!

Check out my blog:

Power BI em Português

Helpful resources


August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors