Solved: Using Sort() Function - Page 2

AdemarN · 08-27-2023 08:36 AM

Hi,

I'm using Top(Sort(Select())) in the expression below and expecting to retrieve the [Group Level] for last row it finds but it is giving me the first row. What am I missing?

TOP(SORT(select(Event Rider Details[Group Level], [_THISROW].[TransponderID]=[Transponder ID]),FALSE),1)

Thanks.

AdemarN

Ok I think I got it. @SkrOYC let me on to something so I did this...

I created a VC on the [Event Rider Details] table that returns a yes/no if the reocord is the Latest Record:

[vcLatest Record] = IF(MAXROW("Event Rider Details","Timestamp",([TransponderID]=[_THISROW].[TransponderID]))=[Row ID],"YES","NO")

Then on the other table I filtered on [vcLatest Record] = "YES":

top(select(Event Rider Details[Group Level],AND([_THISROW].[TransponderID]=[TransponderID],[vcLatest Record]="YES")),1)

We're good to go.

Thanks All.

View solution in original post