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
- 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.