Generate Series of multiple columns

[DavidWaters]

Hi All,

I need to replace a link to Excel data source with a generated series with DAX as follows:

Years 2013 to 2025, with 1-120 for each so 13 years with 1-120 number rows.  Then I need 75 groups of that, denoted 1,2 etc

Thanks so much in advance, I am stuck!

Year	Dev Month	Group
2013	1	1
2013	2	1
For each year	to 120	then 75 groups of this

[DavidWaters]

@amitchandak the dax has been posted to show you what I mean, you can run it

I guess this is solved

[DavidWaters]

@amitchandak 

[DavidWaters]

The above gives me 1 to 120 rows for each year.  Then I need this x75 for 1 to 75

So crossjoin above with Generateseries (1,75,1)

I have solved this by crossjoining the above two tables to get the final solution

[DavidWaters · Accepted solution]

Generated = VAR _numberTab = SELECTCOLUMNS ( GENERATESERIES ( 1, 120 ), "number", [Value] )              

          VAR _valuesTab = GENERATESERIES(2013,2025,1)

RETURN

      CROSSJOIN(_numberTab,  _valuesTab)

[amitchandak]

@DavidWaters ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.