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

Many to Many relationship

Hi,

 

I'm trying to restore my memories about dbs back into place.

I got two simple tables and I want them to be "connected"

 

TABLE 1

user 1; group 1
user 1; group 2
user 2; group 2
user 2; group 3

 

TABLE 2
group 1; link 1
group 1; link 2
group 1; link 3
group 2; link 1
group 2; link 3
group 2; link 4
group 3; link 5

 

The result should be this

 

RESULT TABLE

user 1; group 1; link 1
user 1; group 1; link 2
user 1; group 1; link 3
user 1; group 2; link 1
user 1; group 2; link 3
user 1; group 2; link 4
user 2; group 2; link 1
user 2; group 2; link 3
user 2; group 2; link 4
user 2; group 3; link 5


What is the fastest way to obtain this in powerquery without DAX ? 

Or, is there a "complete" DAX composer ?

1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

Re: Many to Many relationship

Hi @suoko,

 

Based on my test, you should be able to simply use the Merge Queries option in Query Editor to get the expected result in your scenario. For more details about how to use Merge Queries option with Power BI, you can refer to this article. Smiley Happy

 

Regards

2 REPLIES 2
Super User
Super User

Re: Many to Many relationship

You may be able to do that join in Power Query but you could also create a bridge table to do it I believe. And then it is just tabular relationships.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

v-ljerr-msft Super Contributor
Super Contributor

Re: Many to Many relationship

Hi @suoko,

 

Based on my test, you should be able to simply use the Merge Queries option in Query Editor to get the expected result in your scenario. For more details about how to use Merge Queries option with Power BI, you can refer to this article. Smiley Happy

 

Regards

Helpful resources

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.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 42 members 1,009 guests
Please welcome our newest community members: