Beginner: Managing relationships between tables with daily/weekly values

[Basti76]

Hi everyone, 

I have just started with PowerBi. I am using a serious of tables with data from a customer (sales, stock, forecast,...) and I managed to analyse data from individual tables but I am having issues with combining these.

These are 3 tables I would like to combine to get a 4th table with the following data:

Latest stock
Sum of last 4 week of sales

Sum of next 4 weeks of forecast

Stock / Sum of last 4 week of sales

Stock / Sum of next 4 weeks of forecast

Any help is appreciated. 

Thanks,
Bastian

[amitchandak]

@Basti76 , I would have preferred to get a date from week no and year no. and join both these table with a date table

refer to question in this blog for that

https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3

[Basti76]

@amitchandak Thank you for your quick reply. I looked at the links you provided. Unfortunately that is already too advanced for me. I have just upgraded from pivot tables. So, there is still a long way ahead. 

Do you have any example pbix files I could look at? Or a link to get some more informaton about what I have to do?

Thanks again!