Skip to Content
0
Jun 11, 2020 at 04:29 PM

Get the last record for each max date in YYYY-MM

99 Views

Hi,

I have this table:

I am only interested in those records in red.
Basically, I want to find for each TAR Book Code AND TAR Tartrade Reference AND COB Mmm-YY, the latest entry i.e. the one with MAX(COB as Date).

I have colored my table to bring out the sections.

The last column in that table TARUniqueActivityCodeForLate is a variable I created that basically concatenates certain columns. It is defined as:

=[TAR Book Code] + "::" + [TAR Tartrade Reference] + "::" + FormatNumber([TAR Start Date];"0") + "::" + [TAR Tartype]

Can someone please help me.

Thank You,

Jay

Attachments

capture.png (243.2 kB)