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.
Solved! Go to Solution.
ANY(Select(RDR News[ShadeO],[_RowNumber]=
MAX(Select(RDR News[_RowNumber],TRUE))
))
Do you have a column which records the creation date/time or are you happy to to use the most recent _RowNumber?
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.
ANY(Select(RDR News[ShadeO],[_RowNumber]=
MAX(Select(RDR News[_RowNumber],TRUE))
))
That’s it. Thank you very much for such a quick reply
How could I modify this to filter the results by the referenced table I am opening the form under?
ANY(Select(RDR News[ShadeO],AND(
<Your additional rule here>,
[_RowNumber]=MAX(Select(RDR News[_RowNumber],TRUE))
)
))
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |