new table based on 2 tables

[evilmen]

Good morning, could you help me? I have 2 tables, each with multiple fields. I am trying to get fields from the 2 tables and form a new one.

tables 

new table

[v-yangliu-msft · Accepted solution]

Hi  @evilmen ,

Here are the steps you can follow：

1. In Power Query – Merge Queries -- Merge Queries as New.

Table usuarios

Table empresa

The two tables are linked together with [nit empresa].

Join Kind:Left Outer

2. Extend [table empresa] – check [nit empress].

3. Select [saldo],[nit empresa] – Remove Columns.

4. Result:

Best Regards,

Liu Yang

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

[SanKing]

Hi @evilmen ,
You can use SUMMARIZE & ADDCOLUMN, but it depends if you have relation between two tables.

Maybe links below will help you?

https://community.powerbi.com/t5/Desktop/Add-Column-using-value-form-another-table/td-p/171856

https://community.powerbi.com/t5/Desktop/Create-new-table-from-multiple-tables/m-p/946098