**Description**

The** SEQUENCE **function creates a range of numbers as a single column table. This could be a continuous range like the numbers from 1-to-100 or non-continuous range such as [2, 4, 6, 8 10]. Ranges of dates and letters can be produced as well.

**Syntax**

Sequence(*records, start, step)*

*records*– Required. Quantity of numbers in the sequence.*start*– Optional. Starting number of the sequence. Default is 1.*step*– Optional. Incremental value. Default is 1

**Examples**

**Numbers**

A table with all numbers from 1-to-10

`Sequence(10)`

Output: [1,2,3,4,5,6,7,8,9,10] |

A table with all multiples of 10 from 0-to-100

`Sequence(10, 0, 10)`

Output: [0,10,20,30,40,50,60,70,80,90,100] |

A table with numbers from 10-to-1

`Sequence(10, 10, -1)`

Output: [10,9,8,7,6,5,4,3,2,1] |

**Letters**

A table of all letters A-to-Z

`ForAll(Sequence(26, 65, 1), Cha\'r(Value))`

Output: [A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z] |

**Dates**

A table of the next 7 days starting 2020-01-01

`ForAll(Sequence(7), Date(2020, 1, Value))`

Output: [1/1/2020, 1/2/2020, 1/3/2020, 1/4/2020, 1/5/2020, 1/6/2020, 1/7/2020] |

A table of the next 5 Saturdays starts 2020-01-04

`ForAll(Sequence(5, 4, 7), Date(2020, 1, Value))`

Output: [1/4/2020, 1/11/2020, 1/18/2020, 1/25/2020, 2/1/2020] |

A table of the first day of each month in the year 2020

`ForAll(Sequence(12), Date(2020, Value, 1))`

Output: [1/1/2020, 2/1/2020, 3/1/2020, 4/1/2020, 5/1/2020, 6/1/2020, 7/1/2020, 8/1/2020, 9/1/2020, 10/1/2020, 11/1/2020, 12/1/2020] |

A table of the last day of each month in the year 2020

`ForAll(Sequence(12), DateAdd(Date(2020, Value, 1), 1, Months) - 1)`

Output: [1/31/2020, 2/29/2020, 3/31/2020, 4/30/2020, 5/31/2020, 6/30/2020, 7/30/2020, 8/31/2020, 9/30/2020, 10/31/2020, 11/30/2020, 12/31/2020] |

A table of all of the days in the month of January for the year 2020

`ForAll(Sequence(Day(DateAdd(Date(2020, 1, 1), 1, Months)-1), 1, 1), Date(2020, 1, Value))`

Output: [1/1/2020, 1/2/2020, 1/3/2020, 1/4/2020, 1/5/2020, 1/6/2020, 1/7/2020, 1/8/2020, 1/9/2020, 1/10/2020, 1/11/2020, 1/12/2020, 1/13/2020, 1/14/2020, 1/15/2020, 1/16/2020, 1/17/2020, 1/18/2020, 1/19/2020, 1/20/2020, 1/21/2020, 1/22/2020, 1/23/2020, 1/24/2020, 1/25/2020, 1/26/2020, 1/27/2020, 1/28/2020, 1/29/2020, 1/30/2020, 1/31/2020] |

**Random**

A random number between 1-and-100

`First(Shuffle(Sequence(1, 100, 1))).Value`

Output: 67 (changes to another random number each time) |