cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
luisseneto
New Member

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
mwegener
Super User II
Super User II

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 )

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


View solution in original post

5 REPLIES 5
themistoklis
Super User II
Super User II

@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]  ), 			  
			  )

 

 

Thank you @themistoklis !!

mwegener
Super User II
Super User II

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 )

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


View solution in original post

Thank you @mwegener !!

You are welcome

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors