cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nusc
Helper II
Helper II

Table Relationships

omg4.JPGomg5.JPGomg6.JPG

 

The first table represents Day 1, the second Day 2.

 

If I were to import this data in PowerBI in a clustered column chart, I first need to find a relationship between the two tables.

 

I tried relating by Category, however when I click on say the blue bar for Racer 1, it selects both orange and blue but for that Name only (racer 1) and not the just the blue bar.

 

How should the relationships be done?

2 ACCEPTED SOLUTIONS

I was able to create the column in both tables.

 

When I try to merge them: Data->Edit Queries->Edit Queries->Merge Queries->Merge as New->Full Outer Join

 

It doesn't show the second table and the entry that is created appears as blank.

 

Do I merge or append?

 

 Append Worked.

View solution in original post

Hello @Nusc

 

you have to use the 'Append' option which corresponds to the SQL UNION ALL operator.

The 'Merge' option is the equivalent of the different types of JOIN which is not what you want to do in this case.

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

View solution in original post

3 REPLIES 3
LivioLanzo
Solution Sage
Solution Sage

Hello @Nusc

 

within your query, you just need to append both tables together and add an additional column categorizing each table as 'Day 1' for the first table, 'Day 2' for the second table

 

 

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

I was able to create the column in both tables.

 

When I try to merge them: Data->Edit Queries->Edit Queries->Merge Queries->Merge as New->Full Outer Join

 

It doesn't show the second table and the entry that is created appears as blank.

 

Do I merge or append?

 

 Append Worked.

Hello @Nusc

 

you have to use the 'Append' option which corresponds to the SQL UNION ALL operator.

The 'Merge' option is the equivalent of the different types of JOIN which is not what you want to do in this case.

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!