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.

Related Blog Posts

create-a-table-in-power-bi
How-To-Harvest-Power-BI-Slicer-Selections-To-Use-Within-Other-Measures
Power-BI-WHAT-IF-Parameters

Related Support Forum Posts

Normal Distribution Curve
Less Commonly Used Advanced Table Functions
What-if analysis in Direct Query

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

EDNA-TV-show-last-3-sales
creating-great-color-palettes-for-power-bi-data-visualization-tips

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

GENERATE
GENERATEALL

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.