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

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

You can try with:

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

Thank you @Rene_Casana_Amaya.

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

1 Like

This is just what I was looking for!

Thank you so much @Steve

And thanks @Rene_Casana_Amaya

1 Like