Solved: Slice by latest date - Page 2

PatM · 07-27-2020 09:58 AM

Hello,

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 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

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

Thanks for any help,
Pat

hru

For a slice, the expression is something like:

[_ROWNUMBER] =
	MAX(
	  SELECT(
		HcapGUI[_ROWNUMBER],
        ([GolferID] = [_THISROW].[GolferID])
     )
    )

to get the Yes/No expected type.

View solution in original post