Hi @justin.stirling, welcome to the community
Happy to help! For this, here's an example solution that uses FILTER and FINDROW to display the top scores of a user. I put the formulas in the tables to make it easy to call the result in the app. This is how it looks:
Here's a table of Scores, with an associated date and name:
And I have a table of Participants, which I've added columns to pull all scores, the top score, and the top score's associated date.
For the All Scores column, the formula to pull all of a participant's associated scores is:
=FILTER(Scores,"Scores[Name]=[Name]")
The next column uses a combo of FINDROW to call the first row of the [All Scores] FILTER and ORDER BY to sort the score list in ascending order by both score and date. This will return the most recent top score:
=FINDROW((FILTER([All scores],"ORDER BY Scores[Score] DESC, Scores[Date] DESC")))
And the last column calls the associated date of that row we just called of the top score:
=[Most recent top score][Date]
Now in the app, you can call for the top score and date columns for the SYS_USER using formulas like:
=FINDROW(Participants, "Participants[Name]=$[SYS_USER]")[Most recent top score]
=FINDROW(Participants, "Participants[Name]=$[SYS_USER]")[Recent top score date]
You could also add a list object of all of the top scores for all users like this:
Here's how it looks in action:
Hope this helps! Let us know if we can assist any further.