INDEX()

One specific list item

S

Written by Steve Coile Updated over a week ago

Examples

INDEX(Students[Name], 1) : An arbitrary value from the Name column of the Students table. Arbitrary because the order of values in the Students[Name] column list isn't guaranteed unless wrapped in SORT(). Equivalent to ANY(Students[Name]). See also ANY().