This document will be helpful in a scenario where we have multiple records with different dates but dimension is same /Getting most recent record in webi using date dimension.
Here Emp no 107 has Different date of joins but Emp name and sal same.
By using Rank function we can achieve most recent record by creating variable as below .
If you observe Rank has shown 1 ,2 ,3 for 3 different records for Emp 107 as below.
Now apply filter on rank with 1 then it will Table/output will display only one record with most recent data.