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

SHAR8F
Participant I

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

Solved Solved
0 4 2,176
1 ACCEPTED SOLUTION

Steve
Participant V

View solution in original post

4 REPLIES 4

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.

Steve
Participant V

This is just what I was looking for!

Thank you so much @Steve

And thanks @Rene_Casana_Amaya

Top Labels in this Space