Your datasource is of a kind called
Accumulating Snapshot, or Lookup.
A great intro into a Lookup vs Transactional data type is here:
To come to the results you want,
one would need to transform data
into another common type called
This could be done in Tableau one way or another.
My favorite one is using data blending into a Scaffold datasource.
Please find the attached workbook & Scaffold DS.
Hope it could help.