Tracking Data over time question

Hi Anonymous ,

Here's my solution.

1.If your Arrivals tables are multiple separate tables, you need to append them into one table.

2.Rename the table to Arrivals, then click Close&Apply.

3.Make sure there's no relationship between Schedule table and Arrivals table.

4.In the Arrivals table, create two calcualted columns, one is WeekYear and  the other is sort. And sort WeekYear column by sort column.

WeekYear = "Week "&WEEKNUM([Date of Data Download])&" "&YEAR([Date of Data Download])

sort = YEAR([Date of Data Download])*100+WEEKNUM([Date of Data Download])

5.Create two measures.

Product Arrived = CALCULATE(COUNT('Arrivals'[Product-Part ID]),ALLEXCEPT(Arrivals,Arrivals[WeekYear]))

Product Due = CALCULATE(COUNT('Schedule'[Product-Part ID]),FILTER('Schedule',[Date Due]<MAX('Arrivals'[Date of Data Download])))

6.Results is as follows. This is to maximize the effect you want. You can filter by the slicer.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.