If you ever need to create a list of numbers (either decimal or whole number), or list of dates and times, there is a very simple and useful function in DAX which helps. GenerateSeries is a simple function to use to create a list. In this article, I’ll explain how you can use this function. If you want to learn more about Power BI, read Power BI book from Rookie to Rock Star.

Table Generators

There are a set of functions in DAX which generates a table. Some of these functions are from the form of table constructors, I have written about the Table Constructor in DAX, and also the DataTable() function.

There is another set of functions to generate a table. I have written about Calendar() and CalendarAuto() functions and explained how they can be used to create a table with a list of dates. In this article, I am explaining the GenerateSeries() function in DAX and how you can create a table with it.


GenerateSeries is a function in DAX that generates a list of values. The list starts from a Start value and ends at an End value. You can also specify an increment. However, the increment value is optional, and if you don’t set that value, the default increment would be 1.

Read More

Share This