Join Table Man to Many

[efilipe]

Hi guys,

I have a tire table like

Car table

Car name	Tire Weight	Tire Width
Toyota	100	10
Honda	200	10
Mazda	100	40
A	200	80
C	300	120

Tire table

Product	Tire Weight	Tire Width
A	100	10
B	100	10
C	100	40
D	200	80
E	200	80

The result should be

Car name	Tire Weight	Tire Width	Produtct
Toyota	100	10	A
Toyota	100	10	B
Honda	200	10
Mazda	100	40	C
A	200	80	D
A	200	80	E
C	300	120

Basically is a left join it it has many to many relation ship. Bem label in the right has more products with the key Tire Weight and Tire Widht, it will duplicate the product in the left table.

Any ideas?

Thanks

[mwegener · Accepted solution]

Hi @efilipe ,

use Power Query - Merge Queries.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[mwegener · Accepted solution]

Hi @efilipe ,

use Power Query - Merge Queries.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[efilipe]

Doesnt do that. It gets the first product. Doesnt duplicate.

[v-xuding-msft]

Hi @efilipe ,

The answer of mwegener is correct. It works perfectly with M language in Query Editor. If you want to implement with DAX, you could reference this thread:

https://community.powerbi.com/t5/Desktop/left-outer-join-using-dax-Multiple-to-Multiple/td-p/218906

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener · Accepted solution]

Hi @efilipe 

You may download my PBIX file from here.
Hope this helps.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.