GENERATESERIES Function

 

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.

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

Parameters

TermDefinition
startValueThe initial value used to generate the sequence.
endValueThe end value used to generate the sequence.
incrementValue(Optional) The increment value of the sequence. When not provided, the default value is 1.

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

When startValue is less than endValue, 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.

Example 1

The following DAX query:

EVALUATE GENERATESERIES(1, 5)

Returns the following table with a single column:

[Value]
1
2
3
4
5

Example 2

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

Example 3

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
Show: