Skip to Content

Hi,

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.

Sample data:

s1.PNG

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 .

s2.PNG

If you observe Rank has shown 1 ,2 ,3 for 3 different records for Emp 107 as below.

s3.PNG

Now apply filter on rank with 1 then it will Table/output will display only one record with most recent data.

s4.PNG

Thanks.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply