Forum Discussion
new table based on 2 tables
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
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
2 Replies
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
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