Most recent image (2)

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

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]))
4 Likes

Thank you very much for the formula, it works great. You are great. :grinning: :grinning:

2 Likes