Last date from list, based on the key value from another table

[Marko_Nesic]

Hello to everyone, 

Basically I have two tables, 

1. Car list, Registration number column(key value)

2. List of all records for all services of the cars from car list, with Date of  service column

What I want to do is practically, make the virtual column to see when was the last time the car  was serviced

I tried something with lookup, but always get random values

[lynchk21 · Accepted solution]

Try something like:

MAX(SELECT(ServicesTable[Date of Service],[registration number]=[_thisRow].[registration number]))

[Marko_Nesic]

Thanks!!!