How to create many-to-many relationships in power pivot

[hellosunshine]

I would like to link table 1 and table 2 together and the return as the results table. I have tried using many-to-many relationships in power pivot but it doesn't work. Can someone please show me some guidance as to how to tackle this issue?

 

[RoryA]

Surely that's a one to many relationship? Each Dest is only present once in Table1 from what you have shown.