is there a way using DAX to create an index for each row starting from a specific number

[user35131]

ID	Index
101	100000
501	100001
701	100002
801	100003
901	100004
1001	100005
1101	100006
1201	100007
1301	100008

My normal code

ADDCOLUMNS(ID,"Index" ,RANKX(ID,[ID],,ASC,Dense))

gives me

ID	Index
101	1
501	2
701	3
801	4
901	5
1001	6
1101	7
1201	8
1301	9

I would like to keep the same idea but is there a function like Start on(100000) and the index counts from the specific number.

[v-xiaotang · Accepted solution]

Hi @user35131 

Thanks for reaching out to us.

>> My normal code   ADDCOLUMNS(ID,"Index" ,RANKX(ID,[ID],,ASC,Dense))

Actually you are very close to the correct answer.

You can try this DAX expression,

t1 = ADDCOLUMNS('Table',"Index" ,RANKX('Table',[ID],,ASC,Dense),"test",100000+RANKX('Table',[ID],,ASC,Dense))

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[johncolley]

Hi @user35131 , 2 options:

DAX: add +99999 at the end of your code

Power Query: Add an Index Column - there is an option to start at custom number:

If this answer solves your problem please mark it as a solution!