List only the nearest day in the table

[FFBB1983]

Dear all,

I got raw data like this. I only want the most recent visit got listed in the LastVisit column. This means only one record will be presented for one client in the table. I tried to write "=Max(TranDate)" in the field. But this didn't work.

Can anyone help with this? Much appreciated!

ID	FirstName	LastName	City	Province	LastVisit
7049	Alex	Dough	Moncton	NB	6/20/2019
7049	Alex	Dough	Moncton	NB	6/6/2019
7049	Alex	Dough	Moncton	NB	5/16/2019
7049	Alex	Dough	Moncton	NB	5/10/2019
7049	Alex	Dough	Moncton	NB	3/29/2019
7049	Alex	Dough	Moncton	NB	3/14/2019
7049	Alex	Dough	Moncton	NB	3/6/2019

[Ivan_Bozov]

Hi! Include this as a measure:

=ONLY({<LastVisit={"$(=MAX(LastVisit))"}>}ID)

[FFBB1983]

Not working.... Is this because I have thousands of ID in my database?

[Ivan_Bozov · Accepted solution]

Add it as measure, not as dimension.

[FFBB1983]

I wrote this...

But it seems only the Last call in the universal got presented, which is today. I would like to have the last call for every specific client.

[FFBB1983]

Thanks. I found I have solved this issue. Just simply put MAX(TranDate) as a measure.

What went wrong was I put it as dimension.....