I'm not really good with set analysis. I was hoping for something easier. I tried the dimension on the key field and max(your date field). That gives me the latest date. But I failed to mention that there are multiple primary key records, like this:
So, for each primary key I need the latest date. Sorry for not explaining that.