cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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?

1 REPLY 1
Highlighted
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

Meger.png

 

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:

 

merge_erros.png

 

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

 

Regards,

MFelix

 


Regards

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

Announcements

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