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:
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.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |