Forum Discussion

dk_24's avatar
dk_24
Icon for Helper I rankHelper 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
Icon for Microsoft Employee rankMicrosoft Employee
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)
dk_24's avatar
dk_24
Icon for Helper I rankHelper I
8 years ago

sorry i have cretead meaasure.now its working as expected. thanks.