The First and Last measures address values based on the physical order of the data rows.

First returns the first valid value in the selected column, and Last returns the last valid value.