Power Fx function
FirstN / LastN — Power Fx function reference
Get the first or last N records.
Syntax
powerfx
FirstN( Table, Count ) / LastN( Table, Count )
Examples
powerfx
FirstN(Orders, 10)
→ Top 10
powerfx
FirstN(SortByColumns(Orders, "Created", SortOrder.Descending), 5)
powerfx
LastN(colActivityLog, 20)
Common mistakes & gotchas
- Count defaults to 1 if omitted, matching First()/Last(); most real usage passes an explicit number.
- Raw data-source row order is not guaranteed — pair FirstN/LastN with an explicit Sort/SortByColumns for a reliable "top N" result.
Related Power Fx functions
From Filtering, search & sort