There are actually many methods and variations to achieve what you are looking for, including custom SQL, table calculations, and my preferred for this exact situation, self data blend.
Bear in mind, that if you want anything in addition to what you have described here, the approach may need to be altered to fit your exact situation and desired final display. There are many factors to be aware of, and you have only supplied the minimum of details.
I would not initially recommend the table calculations in version 7 (unless there were other constraints) because you are dealing with an exact date, and Tableau version 7 will HEAVILY pad your data when the compute using is an exact date, and the custom SQL may add slowness if you are dealing with a live connection.
1. duplicate your data data source so you have a "(copy)"
2. from the Data menu, Edit Relationships, and have a Custom with just "Group" kept
3. bring out your fields of interest from the primary.
4. in the primary data source (one with blue checkmark), create a calc field like:
IF MAX([Date])=MAX([Data Source (copy)].[Date]) THEN 1 END
5. place this calc field on the Filter shelf, and accept the default, keeping only the range from 1 to 1
This is done in the attached.
max data.twbx.zip 4.1 KB
Thanks for your help. It's helpful.