Forum Discussion
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(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 wrote:
Please fnd the below picture ,
please let me know if your not clear with this.
Thanks,
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)
6 Replies
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.
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.
Please fnd the below picture ,
please let me know if your not clear with this.
Thanks,
dk_24 wrote:
Please fnd the below picture ,
please let me know if your not clear with this.
Thanks,
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)
