GENERATESERIES

Syntax

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

Tutorial with example

In this video we will through the GENERATESERIES function in DAX. This function is useful to create a serie of numbers between two digits or to carry out a what-if analysis.

Download example file:

Download Power BI file (Part 1): Link to SQLDusty blog

Remarks

1. When startValue is less than endValue, an empty table is returned.
2. IncrementValue must be a positive value.
3. The sequence stops at the last value that is less than or equal to endValue.