Dear colleagues

i have a report that i need to use power query for it , what i am trying to do is to gather many information from differents tables, my issue that i started to face the M2M relationships issues , Would you check my example in attach and let me know how to complete it ?
from each table i will need specific info :

Table 1 : its forecast order => i will need the forecast requirement according the ship to code.
Table 2 : its the delivered quantity => i will need the delivered quantity according ship to code.
Table 3 : its the customer build car per Month according ship to.

In in the end i will need to have all of them in pivot table and summary as below :

Customer Month Week Customer build forecast order Delivered quantity
600560 March 10 1500 2000 3500

how can i gather them ?

thank you.