Trouble on table relationships

Hi everyone,

I'm trying to build my Order Schedule in a Power BI report, but I'm having problems understanding or trying to figure out the correct relationships between tables.

First of all, the report has two different purposes. Show Orders and Production quantities along time and to save data week by week so you can check and compare Production quantities over weeks, e.g. Production orders are not fixed, so you might want to check on week 48 what you had planned for week 50, and then on week 49... Searching for variations.

Clarification: Data is saved running a batch with task scheduler, and appending data into different .txt files. One for each table.

On this image you'll understand it better: 

I am not getting the right data due to table relationships. As I am saving data week by week and there are several products, relationships are many to many, and its difficult to understand...

Here are my tables and the relationships:

Dates: Dates table

OWOR: Production orders

ORDR: Clients orders

OITW: Current stock

All tables have information from when they were taken.

As you can see OWOR and ORDR are related to DATES by the DueDate of the document, so that the matrix shows data correctly.

Trouble comes within the WeekSnapshots, i want to get data from past weeks but mixes up and doesn't show the right information.

Clarification: OITW (stock) and ORDR (orders) should be related by itemcode,but it wont let me due to many to many relationships with OWOR.

If you need any more information just let me know.

Any advice?