GENERATESERIES Function (DAX)

How does the GENERATESERIES function (DAX) work?

It returns a single column table that comprises the values of an integer series, that is, a sequence of values in which a constant quantity varies each from the preceding. The returned column name is Value.

GENERATESERIES Formula Syntax

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

How do you use the GENERATESERIES function?

GENERATESERIES is a function generating a list of values in DAX. The list starts at a Start value and ends at an End value. You may define an increment too. The increment value is optional, however, if you don’t set the value the default increment is 1.

Considerations when using the GENERATESERIES function

If startValue is less than endValue it returns an empty table. IncrementValue has to be positive. The sequence stops under or equal to endValue at the last value.

Formula examples using the GENERATESERIES function

EVALUATE GENERATESERIES(1, 5)

EVALUATE GENERATESERIES(1.2, 2.4, 0.4)

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

Related DAX Functions

Related Course Modules