Forum Discussion

dk_24's avatar
dk_24
Helper I
8 years ago
Solved

Index for text table

Hi All,   i have to give the serail number to the text table like 1,2,3.for that i have created one index column.i have total 30 rows in source,so it's given 1 to 30 numbers.but when i summarige(Av...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago
    dk_24 wrote:

    Please fnd the below picture , 

     

     

    please let me know if your not clear with this.

     

    Thanks,

    dk_24

    So what you need is the index column? I'm not clear about what did you do while getting 27,28,29 as described, however you can create a calculated column with DAX.

    index = RANKX(yourTable,yourTable[UserName],,ASC,Dense)
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
8 years ago
dk_24 wrote:

Hi All,

 

i have to give the serail number to the text table like 1,2,3.for that i have created one index column.i have total 30 rows in source,so it's given 1 to 30 numbers.but when i summarige(Average the 30 records user wise) it giveing 27,28,30 instead of 1,2,3.

how t get the index for the below text table.

 

dk_24

Your description is not clear for me, would you mind sharing the pbix file? You can upload it to Onedrive/GoogleDrive and share the download link. Do remember to mask sensitive data before uploading.