getting single column from filter function

[Anonymous]

ok so say i have a table with a list of names and dates

jim 2/5/2020

jim 2/3/2020

jim 2/25/2020

and i have another table with names that has a many to one association with the above table so

Jim

i want to find what the most recent date is and save it in the single table like

jim 2/25/2020

I know MAX will get you the highest date but i can't seem to figure out how to filter the first table based on a name and then just get the date column from the filter function to check the max on

[v-yingjl]

Hi @Anonymous ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[camargos88 · Accepted solution]

Hi @Anonymous ,

Try this: