GENERATESERIES

Applies to: Calculated column Calculated table Measure Visual calculation

Returns a single column table containing the values of an arithmetic series, that is, a sequence of values in which each differs from the preceding by a constant quantity. The name of the column returned is Value.

Syntax

DAX
GENERATESERIES(<startValue>, <endValue>[, <incrementValue>])

Parameters

Term Definition
startValue The initial value used to generate the sequence.
endValue The end value used to generate the sequence.
incrementValue (Optional) The increment value of the sequence. When not provided, the default value is 1.

Return value

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.

Example 1

The following DAX query:

DAX
EVALUATE GENERATESERIES(1, 5)

Returns the following table with a single column:

[Value]
1
2
3
4
5

Example 2

The following DAX query:

DAX
EVALUATE GENERATESERIES(1.2, 2.4, 0.4)

Returns the following table with a single column:

[Value]
1.2
1.6
2
2.4

Example 3

The following DAX query:

DAX
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