Auto complete the date field

[Gunasuriya_Ravi]

I am having a table employee with employee email id ,date ,name
In this employee table ,i am having a employee name called john as three record with different Date
Im having another table has Task,i need to get the latest date column value from the Employee table in this table date column
Any idea to achieve this…

[Marc_Dillon]

Try:

MAX( Employees[Date] )

[Steve]

Or:

MAX(SELECT(Employees[Date], ([Name] = "John")))