DAX Function Guide

GENERATESERIES
Empty image or helper icon

Sam McKay

CEO & Founder

How does the GENERATESERIES 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?

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.

Related Blog Posts

Loading

Considerations when using the GENERATESERIES?

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.

Related Video Tutorials

Loading

Formula examples using the GENERATESERIES
EVALUATE GENERATESERIES(1, 5)
EVALUATE GENERATESERIES(1.2, 2.4, 0.4)
EVALUATE GENERATESERIES(CURRENCY(10), CURRENCY(12.4), CURRENCY(0.5))
Related Courses

Loading