DAX function
GENERATESERIES — DAX function reference
Build a numeric series.
Syntax
dax
GENERATESERIES(<start_value>, <end_value>, [<increment_value>])
Examples
dax
GENERATESERIES(1, 12, 1)
→ A one-column table
dax
SELECTCOLUMNS(GENERATESERIES(0.05, 0.5, 0.05), "Discount Tier", [Value])
→ A disconnected table of discount percentages for a what-if slicer
A quick way to backfill a calendar table, though a dedicated Date table built in Power Query is the more maintainable long-term approach.
dax
GENERATESERIES(DATE(2020,1,1), TODAY(), 1)
→ A day-by-day date series
Common mistakes & gotchas
- The generated column is always named "Value" — reference it as [Value] or rename it immediately with SELECTCOLUMNS if you need a more descriptive name.
- GENERATESERIES materializes a real table at query time, not a lazy range — a very large range used as a calculated table (rather than an inline expression) can noticeably affect performance and model size.
Related DAX functions
From Tables & set operations