Return values for most recent row only

[Nick_S]

Hey guys, I’m assuming this is likely an easy one… I’ve spent quite a while reading on it though, and haven’t been able to figure it out yet, so here we are!

I’ve got a column that is using the expression: RDR News[ShadeO]
However, this is filling the column with all previous values in the [ShadeO] column; I just want the most recent. I tried messing with Select() and Lookup() but was unsuccessful so far.

Thanks for any assistance on this as always.

[1minManager]

Do you have a column which records the creation date/time or are you happy to to use the most recent _RowNumber?

[Nick_S]

There is a date column, and records are only added once a week. However, I’d also be fine with simply using the most recent _RowNumber, since records are not added very often and will always be looking to pull just from the most recent.

[1minManager · Accepted solution]

ANY(Select(RDR News[ShadeO],[_RowNumber]=
   MAX(Select(RDR News[_RowNumber],TRUE))
))

[Nick_S]

That’s it. Thank you very much for such a quick reply

[Driller]

How could I modify this to filter the results by the referenced table I am opening the form under?

[1minManager]

ANY(Select(RDR News[ShadeO],AND(
   <Your additional rule here>,
   [_RowNumber]=MAX(Select(RDR News[_RowNumber],TRUE))
)
))