GENERATESERIES

GENERATESERIES 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

GENERATESERIES(startValue, endValue[, incrementValue])

Parameters

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.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Other Functions / GENERATESERIES