Forum Discussion
efilipe
6 years agoHelper IV
Join Table Man to Many
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 ...
mwegener
6 years agoMost Valuable Professional
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
6 years agoHelper IV
Doesnt do that. It gets the first product. Doesnt duplicate.
- v-xuding-msft6 years agoCommunity Support
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.