What am I missing here? I'm having trouble putting together the syntax to Collect the last 10 records from a data source.
The data source has a unique ID and data columns, but these aren't really queryable in this case. I was thinking something like:
ClearCollect( colLast10, Filter(dataSource, x -y))
But I can't figure out what "x" nor "y" could be. CountRows(dataSource) - 10? Nope, Last(dataSource) - 10? NOpe
... Any ideas?
Solved! Go to Solution.