Power Query / Power pivot : M2M relationships problem

[almourasel]

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.

[alansidman]

No attachment uploaded.

[almourasel]

Sorry , yes i attach it now.
all input files they are in same folder , i hope that connection with work when you test it at your desk .
thank you.

[almourasel]

Any try with my file?

[alansidman]

There are six files in the zip folder. Please explain which ones are needed to be anlayzed. How are you joining them? Which ones. Tell us more. I am not a mind reader. Step by step what you want to do.

[almourasel]

hello

i will explain :

I have 4 excel files in 1 folder => its the input excel file from where i made the liaison.
excel file named Book1 => its the file that contain the power query analysis and the one that all analysis will be done inside it.
the file PQManagement => its the structure for the structure of the file : from where we have to get data , how it will be projected and what we need to see as summary.

as there is alot of repeated info per table i had to create a separate table for the multiple ones , the issue with the table of car build which is not allowing to be in relationships with others , something missing i cound't identify it.

[almourasel]

sorry i was busy last days i coudnt give more details.
first were you able to get the connection works?