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.
Related Blog Posts
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.
Related Video Tutorials
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))