Good Afternoon,
What I am looking to do in Power Pivot is to bring a value dependant on two other columns within the same table.
What I did first: got the latest date for a name entered in the table. I now need to match an ID number based on teh name and the date.
For example:
ID | Name | Date | Latest Date | ID Number
1 | John | 1/1/2018 | 1/5/2018 |
2 | Kyle | 1/15/2018 | 1/30/2018 |
3 | John | 1/5/2018 | 1/5/2018 |
4 | Kyle | 1/30/2018 | 1/30/2018 |
What I need is:
ID | Name | Date | Latest Date | ID Number
1 | John | 1/1/2018 | 1/5/2018 | 3
2 | Kyle | 1/15/2018 | 1/30/2018 | 4
3 | John | 1/5/2018 | 1/5/2018 | 3
4 | Kyle | 1/30/2018 | 1/30/2018 | 4
Any ideas on how to accomplish script to accoplish this?