Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: Calculated column Calculated table Measure Visual calculation
Returns a single column table containing the values of an arithmetic series, that is, a sequence of values in which each differs from the preceding by a constant quantity. The name of the column returned is Value.
GENERATESERIES(<startValue>, <endValue>[, <incrementValue>])
Term | Definition |
---|---|
startValue |
The initial value used to generate the sequence. |
endValue |
The end value used to generate the sequence. |
incrementValue |
(Optional) The increment value of the sequence. When not provided, the default value is 1. |
A single column table containing the values of an arithmetic series. The name of the column is Value.
When endValue is less than startValue, an empty table is returned.
incrementValue must be a positive value.
The sequence stops at the last value that is less than or equal to endValue.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
The following DAX query:
EVALUATE GENERATESERIES(1, 5)
Returns the following table with a single column:
[Value] |
---|
1 |
2 |
3 |
4 |
5 |
The following DAX query:
EVALUATE GENERATESERIES(1.2, 2.4, 0.4)
Returns the following table with a single column:
[Value] |
---|
1.2 |
1.6 |
2 |
2.4 |
The following DAX query:
EVALUATE GENERATESERIES(CURRENCY(10), CURRENCY(12.4), CURRENCY(0.5))
Returns the following table with a single column:
[Value] |
---|
10 |
10.5 |
11 |
11.5 |
12 |
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today