Extract dimensional data with for last date value

Hi experts! I have a report that saves every week some dimensional data. It's like 30 columns for each article and every week. It happens that a article is removed from one week to another etc. I...