Solved: Most recent image (2) - Page 2

Palmbus_Palminf · 05-26-2021 02:56 AM

Hello, for simplicity, I have a Bus number column, a bus image column and a date column. I would like to retrieve for each row in virtual column, the most recent image of the bus number of this row.
But obviously the max function only uses numeric values.
Here is my formula:

max(select(carrosserie[schema],and([bus]=[_thisrow].[bus],[date_avar]=max(carrosserie[date_avar]))))

The inputs for function ‘MAX’ should be a list of numeric values

WillowMobileSys

You can use MAXROW like below - I’m not clear which column is your key column so I’ll just refer to it as “Key” and you will want to replace with the actual column:

SELECT(carrosserie[schema], [Key] = MAXROW("carrosserie", "date_avar", [bus]=[_thisrow].[bus]))

View solution in original post