Slice by latest date (Part II)

[PatM]

Hello,

This is slight variation of the solution already answered in https://community.appsheet.com/t/slice-by-latest-date/28435

Trying to create a slice that is filtered based on latest date. Example given below where the golfer with the latest date is returned (i.e. ID#3 and ID#5 is removed from the slice)

Data
ID GolferID Type Hcap Date
1 1 GUI 16 29/06/2020
2 2 GUI 12 29/06/2020
3 3 GUI 18 29/06/2020
4 3 GUI 17 16/07/2020
5 3 GUI 16 10/07/2020

Slice
ID GolferID Type Hcap Date
1 1 GUI 16 29/06/2020
2 2 GUI 12 29/06/2020
4 3 GUI 17 16/07/2020

The previous solution worked (i.e. ID#3 was removed from the slice) as it used the max row which is no good to me now as an older Date ID#5 has been added as a new row
[_ROWNUMBER] =
MAX(
SELECT(
HcapGUI[_ROWNUMBER],
([GolferID] = [_THISROW].[GolferID])
)
)

Thanks for any help,
Pat

[Steve · Accepted solution]

Try:

ISBLANK(
  FILTER(
    "HcapGUI",
    AND(
      ([GolferID] = [_THISROW].[GolferID]),
      ([Hcap Date] > [_THISROW].[Hcap Date])
    )
  )
)

[PatM]

Steve:

ISBLANK(
  FILTER(
    "HcapGUI",
    AND(
      ([GolferID] = [_THISROW].[GolferID]),
      ([Hcap Date] > [_THISROW].[Hcap Date])
    )
  )
)

Thank you Sir Steve

Isaiah 42:7
To open the eyes that are blind, to bring out the prisoners from the dungeon, from the prison those who sit in darkness.