Solved: Filtering only last unique rows in a column and sh... - Page 2

David_H1 · 05-05-2019 09:35 AM

How can I filter all the last unique records to show in a deck view.

Example:

DATE NAME PRIVILEGES
1.1.2019 Helen 1
1.1.2019 Miriam 1
1.12019 George 2
2.1.2019 Helen 1
2.1.2019 Miriam 1
2.12019 George 2

I would only like to filter last unique rows from NAME column. So that I would see only those records in a deck view:

2.1.2019 Helen 1
2.1.2019 Miriam 1
2.12019 George 2

Thank you in advance!

Steve

If you’re using a slice:

(
  [_ROWNUMBER]
  = MAX(
    SELECT(
      MyTable[_ROWNUMBER],
      ([Name] = [_THISROW].[Name])
    )
  )
)

Filtering only last unique rows in a column and showing them in a deck view