First and Last

First returns the first valid value based on the physical order of the rows of data in the selected column.

Last returns the last valid value based on the physical order of the rows of data in the selected column.