Facilitating many to many relationships

In this video, I'd like to show "How facilitate Many to Many relationships using the Power Query and PowerPivot". You may read up on the question and download the workbook at this link - www.ashishmathu...

[@LotfyKozman]

This is one of the most powerful videos I have ever practically seen.

[@ROMPJ]

This is very nice demo to present the power of PowerQuery. But what it demonstrates is two tables product based on common key. "Many to many relationship" is slightly different concept. If there Customers would have theirs own table with additional attributes like "city", and you would need to group on cities then it would be "many-to-many relationship". And actually it would be very interesting to see DAX query for such type of merge.

[@karldc83]

Great video! Thank you

[@excelenthusiasts]

+Karl C You are welcome.

[@soundlee3399]

Good solution. Merge in Power Query

[@excelenthusiasts]

Byung-Min Lee You are welcome.

[@dalattar]

Hi
May I know where I find the Power Query from?

[@excelenthusiasts]

Hi. If you use Excel 2013, you will have to download it separately from the Microsoft website (just Google for Power Query). If you use Excel 2016, it is already included there. Just go to Data > Get & Transform.