GENERATESERIES

GENERATESERIES is a DAX function that returns a table with a single column containing a sequential series of values from a start to an end value.

Syntax

GENERATESERIES(
   StartValue,
   EndValue,
   IncrementValue
)

Argument	Properties	Description
StartValue		The start value of the column.
EndValue		The end value of the column.
IncrementValue	Optional	The increment value of the column.

Return Values

A single column table containing the values of an arithmetic series. The name of the column is Value.

Remarks

• When endValue is less than startValue, an empty table is returned.

• incrementValue must be a positive value.

• The sequence stops at the last value that is less than or equal to endValue.

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

The following DAX query:

EVALUATE GENERATESERIES(1, 5)

Returns the following table with a single column:

[Value]
1
2
3
4
5

The following DAX query:

EVALUATE GENERATESERIES(1.2, 2.4, 0.4)

Returns the following table with a single column:

[Value]
1.2
1.6
2
2.4

The following DAX query:

EVALUATE GENERATESERIES(CURRENCY(10), CURRENCY(12.4), CURRENCY(0.5))

Returns the following table with a single column:

[Value]
10
10.5
11
11.5
12

Related functions

Other functions related to GENERATESERIES are:

• DATATABLE
• ROW

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/generateseries-function-dax