How to return a specific column value from a MAXROW() Expression

[SHAR8F]

Hello,

I need to return only the date from this expression

MAXROW(“DAILY OPERATIONS”, “DATE”, ([SHOP NAME] = [_THISROW].[SHOP NAME]))

and compare it to

TODAY().

Example, a certain event will happen only if The Date Value, from the date column, of the row returned by
MAXROW(“DAILY OPERATIONS”, “DATE”, ([SHOP NAME] = [_THISROW].[SHOP NAME])) is before TODAY().

Thanks

[Rene_Casana_Ama]

You can try with:

IF(
TODAY() > MAXROW(“DAILY OPERATIONS”, “DATE”, ([SHOP NAME] = [_THISROW].[SHOP NAME])),
TRUE,
FALSE
)

[SHAR8F]

Thank you @Rene_Casana_Amaya.

However this returns an error as the formula attempts to compare a constant to a row number.

[Steve · Accepted solution]

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()

[SHAR8F]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()

LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), “My Table”, “_ROWNUMBER”, “Wanted Column” )

This is just what I was looking for!

Thank you so much @Steve

And thanks @Rene_Casana_Amaya