I have a table called Mileage that allows users to record their daily start and stop odometer reading. I created a virtual column called MostRecent that grabs the last entry based in a timestamp: MAXROW(Mileage, Timestamp)
This is so I can set the initial value of the odometer start with MostRecent (yesterdayโs end reading) Itโs working but I need it to look for the current userโs last entryโฆ not just the last entry. Is there some kind of WHERE clause I can use when setting my initial value = MostRecent?
My Mileage table has an email field so I like to specify WHERE UserEmail() = Email
Solved! Go to Solution.
For anyone seeking a similar solution I creates a virtual column with a REF type called MostRecent with anapp formula:
MAXROW(Mileage.xlsx, Timestamp, ([Driver Name] = Useremail()))
Then auto computed the Odometer Reading End with this:
[MostRecent].[Odometer Reading End]
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |