cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
luisseneto Frequent Visitor
Frequent Visitor

Create a new table from multiple tables

Hi,

 

I'm trying to joining multiple tables and i dont know how to do it.

 

 

Table 1:

idnamevalue
1aaa123
2bbb234
3ccc345

 

Table 2:

idnamevalue
1aaa432
2bbb543
4ddd154
5eee346
6fff908

 

Expected result:

idnameTable1.valueTable2.value
1aaa123432
2bbb234543
4dddnull154
5eeenull346
3ccc345null
6fffnull908

 

I tried to append, merge this queries using FULLOUTERJOIN, however i wasnt successfull.

Someone please can help me?

1 ACCEPTED SOLUTION

Accepted Solutions
mwegener Member
Member

Re: Create a new table from multiple tables

Hi @luisseneto,

 

1. rename the value columns (Table1.value, Table2.Value)

2. Append Table1 & Table2

3. Group by id, name (Sum Table1.Value, Table2.Value )

5 REPLIES 5
mwegener Member
Member

Re: Create a new table from multiple tables

Hi @luisseneto,

 

1. rename the value columns (Table1.value, Table2.Value)

2. Append Table1 & Table2

3. Group by id, name (Sum Table1.Value, Table2.Value )

themistoklis New Contributor
New Contributor

Re: Create a new table from multiple tables

@luisseneto

 

Create a new table and add the following formula:

 

Table = UNION(SELECTCOLUMNS(Table1,"ID", Table1[id],"Name", Table1[name],"Value1", Table1[value],"Value2", ""  ), 
              SELECTCOLUMNS(Table2,"ID", Table2[id],"Name", Table2[name],"Value1", "","Value2", Table2[value]  ), 			  
			  )

 

 

luisseneto Frequent Visitor
Frequent Visitor

Re: Create a new table from multiple tables

Thank you @mwegener !!

luisseneto Frequent Visitor
Frequent Visitor

Re: Create a new table from multiple tables

Thank you @themistoklis !!

Highlighted
mwegener Member
Member

Re: Create a new table from multiple tables

You are welcome

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 218 members 2,299 guests
Please welcome our newest community members: