Two Datelist combined in one new table

[Mako111]

Hi all, 

i have following problem regarding combing two tables into one: 

On the first list i have a lot of goods receiped dates per article with quantities, but same article can arrive on different dates! 

e.g.

Article Date 1         Quantity   

12345 01.01.2015  10

12345 03.01.2015  20

11111 02.02.2015  30

...

On my second list i also have an article number with a quantity and a date when the article left the warehouse. Same issue as above, i can have different dates to same article.

Article Date 2         Quantity   

12345 01.12.2016  5

22222 01.01.2015  20

11111 05.05.2015  20

...

Most of the dates in the lists are the same, but every list has also dates which are not displayed in the other. 

Now i am trying to create a graph where i have all dates (from first list and second list) displayed in the x axis and then one column displaying the quantities which arrived this day in total and the quantities which left in total. 

I already tryed a lot with creating new tables but always dates from one table which were not displayed in the other got lost.

Would be great if somebody could help me!

THANKS 

[MFelix]

Hi @Mako111,

Create a dimension table with a calendar and the related this table with both tables you have on your model by the date, then add on the x-axis the date from dimension table and the quantities from both your table should work.

Be aware that if you want to make selections by article you also need to have a dimension table related with both tables.

See attach the PBIX file, with both relations active.

Regards,

MFelix

[Mako111]

Hi @MFelix 

thanks for your super quick answer. This already helped a lot but still sth. is not working right. Now i have the same value for every day displayed. 

Maybe it relates to the fact that i just don´t have the same article number more often in every table, i have also the same day more often in every table, e.g. 

Article Date 1         Quantity   

12345 01.01.2015  10

12345 03.01.2015  20

11111 02.02.2015  30

22222 02.02.2015  20

...

Thanks for your help again! 🙂

[MFelix · Accepted solution]

Hi @Mako111,

This happens when you don't have the relationship active, you need to have the relationshp between date table and both tables active.

[Mako111]

TRUE!

Thank you so much for solving the issue!