Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Join tables

Hello I would like to join table 1 and table2 who has common project name, and would like to have value3 repeated. I know the question has been already asked but couldnt find it. Apologies for the ...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, Anonymous 

    According to your picture, I think you want to merge table1 and table2 and repeat value 3, you can achieve this in Power query editor, you can try my steps:

    1. Go to Power query editor, select table1, click merge query as new:

     

    1. Set the merge query like this:

    1. Expand the table, then change the column name and table name

     

    And you can get what you want, like this:

    You can download my test pbix file here

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, Anonymous 

According to your picture, I think you want to merge table1 and table2 and repeat value 3, you can achieve this in Power query editor, you can try my steps:

  1. Go to Power query editor, select table1, click merge query as new:

 

  1. Set the merge query like this:

  1. Expand the table, then change the column name and table name

 

And you can get what you want, like this:

You can download my test pbix file here

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.