Forum Discussion

mrothschild's avatar
mrothschild
Icon for Continued Contributor rankContinued Contributor
7 years ago
Solved

Creating calculated index column in DAX

I've searched the forums and haven't found a clear answer to this.  I'm fairly new, but this worked for me and I thought could be helpful for others.   I have a calculated table, so couldn't create...
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, mrothschild 

    It's pleasant that your problem has been solved, and share your solution.

    Usually, create an "Index" column in dax is the same logic as yours.

    And it needs a unique column(eg. UniqueId), otherwise, for the same row will have the same index number.

    You could also try to add multiple group rank column by different level then add then index column by the conditional

    level1*1000+level2*100+level3*10...

    It is like the way as you created a column called UniqueID: 

    UniqueID = 
FORMAT(VALUE(Table[Number]),"00#") & " - " & Table[Asset ID]  & " - " & FORMAT(Table[Period],"000#")

     

    And please close the topic and mark the relevant post as an answer. Thank you Smiley Happy

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, mrothschild 

It's pleasant that your problem has been solved, and share your solution.

Usually, create an "Index" column in dax is the same logic as yours.

And it needs a unique column(eg. UniqueId), otherwise, for the same row will have the same index number.

You could also try to add multiple group rank column by different level then add then index column by the conditional

level1*1000+level2*100+level3*10...

It is like the way as you created a column called UniqueID: 

UniqueID = 
FORMAT(VALUE(Table[Number]),"00#") & " - " & Table[Asset ID]  & " - " & FORMAT(Table[Period],"000#")

 

And please close the topic and mark the relevant post as an answer. Thank you Smiley Happy

 

Best Regards,

Lin