Offset / Skip function

[SamPhillips]

Quite often I have the need to skip/offset the first few records of a table/items of a gallery.

In SQL the offset function allows you to specify offset -1 to skip the first row.

I have managed to faciliate this with the help of this community with the below, but it's somewhat complex for such a simple function.

LastN( SortByColumns( Filter( '[dbo].[MyTable]', TextColumn = TextInput1.Text), "DateColumn", Descending), CountRows(Filter('[dbo].[MyTable]', TextColumn = TextInput1.Text)) - 1)

[CWesener]

Updating status and adding @GregLi

[BARD]

Looking for this feature as well.

[bgigliotti]

This would be great!