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
- When startValue is less than endValue, 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.
[Total: 0 Average: 0/5]
« Back to Index
Let us know your thoughts...