GENERATESERIES DAX Function

The GENERATESERIES DAX 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.

DAX Syntax GENERATESERIES(startValue, endValue[, incrementValue])

The function has the following 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.

Note: The start and end value for the sequence can be positive or negative. The incrementValue of the sequence must be non-zero and positive.

Example: Let’s create a New Table with the below DAX formula.

DAX