Just found this and thought I would put it up here as a brilliant solution that I’d never considered. I have been using windowing functions in a SQL derived table.
Finds the last row in a group (usually by date) and - crucially - makes the other values in the table accessible.
https://community.looker.com/lookml-5/only-measuring-the-latest-values-6719