Generating number sequence in SSAS 2016

user_1820424 0
Viewed 110

I'm trying to generate a sequence of numbers in a calculated table for a SSAS 2016 1200 Tabular model.

What i'm trying to achieve is is to generate number sequence like 1,2,3..100 in a single column. Just like the GENERATESERIES() DAX function does, but it is only available in SSAS 2017 and onward.

Is there a good a simple way to achieve the same thing in SSAS 2016?

dax ssas
1 Answers

Yes, in SSAS 2016 you can use CALENDAR and then cast the Date to an int, like for instance

EVALUATE
SELECTCOLUMNS ( CALENDAR ( 1, 100 ), "Value", INT ( [Date] ) )

here is the link to a working implementation on dax.do

user_2489490
Related