Virtual column that displays las updated row of child table

[Rene_Casana]

I have a table shipments and shipment_stat_reports that has a column “status” and “timestamp” at the time of the report. I want to build a virtual column that displays the last status of the shipment based on the most recent update but I don’t know how. I’ve tried with filter and select but no success

[Lynn]

Hi @Rene_Casana
Maybe check out MAx and MAXROW
https://www.appsheet.com/Support?idx=help&p=0&is_v=1&q=MAX

[Steve · Accepted solution]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I get the last row of this thing only? MAXROW( "My Table", "_ROWNUMBER", ([_THISROW].[Thing] = [Thing]) ) Replace My Table with the name of the table whose row you want; and Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID).

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), "My Table", "_ROWNUMBER", "Wanted Column" ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()