I have this data:

I would like the data in the Index column to not skip numbers but go in sequence -11112222222222233
I found definitions for the Supporting and Index columns in another location (sorry, I do not have the link). But here is what the responder advised:
The Supporting Column is created using:
=CALCULATE (
MIN ( Table[Index] ),
ALLEXCEPT ( Table, Table[id], Table[yr]))
Index column is created by:
=RANKX (ALL(Table),Table[Supporting Column],,ASC, Dense )
I cannot get the Index Column produce the mentioned result.
Please help.



