Power Fx function
Sequence — Power Fx function reference
Generate a numeric table.
Syntax
powerfx
Sequence( Records [, Start ] [, Step ] )
Examples
powerfx
Sequence(5)
→ 1, 2, 3, 4, 5
Months 1 through 12.
powerfx
Sequence(12, 1)
Produces 0, 5, 10, ... 45.
powerfx
ForAll(Sequence(10, 0, 5), Value)
Common mistakes & gotchas
- Sequence produces a single-column table with the column named "Value" — reference each item as .Value inside ForAll/AddColumns.
- Useful for generating fixed-size ranges (pagination controls, repeating a control N times) when there is no real data source to drive a gallery.
Related Power Fx functions
From Table shaping