Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Data | Expect result | ||||||
Sub | Value | Index | Sub | Value | Index | ||
ABC | 30 | ABC | 30 | 4 | |||
ABC | 13 | ABC | 13 | 9 | |||
ABC | 44 | ABC | 44 | 2 | |||
ABC | 25 | ABC | 25 | 5 | |||
ABC | 37 | ABC | 37 | 3 | |||
ABC | 11 | ABC | 11 | 10 | |||
ABC | 16 | ABC | 16 | 8 | |||
ABC | 47 | ABC | 47 | 1 | |||
ABC | 22 | ABC | 22 | 7 | |||
ABC | 23 | ABC | 23 | 6 | |||
DEF | 24 | DEF | 24 | 7 | |||
DEF | 28 | DEF | 28 | 5 | |||
DEF | 28 | DEF | 28 | 6 | |||
DEF | 33 | DEF | 33 | 4 | |||
DEF | 10 | DEF | 10 | 10 | |||
DEF | 22 | DEF | 22 | 9 | |||
DEF | 49 | DEF | 49 | 1 | |||
DEF | 37 | DEF | 37 | 3 | |||
DEF | 44 | DEF | 44 | 2 | |||
DEF | 24 | DEF | 24 | 8 | |||
GHI | 10 | GHI | 10 | 10 | |||
GHI | 37 | GHI | 37 | 2 | |||
GHI | 43 | GHI | 43 | 1 | |||
GHI | 14 | GHI | 14 | 9 | |||
GHI | 24 | GHI | 24 | 6 | |||
GHI | 17 | GHI | 17 | 8 | |||
GHI | 36 | GHI | 36 | 3 | |||
GHI | 22 | GHI | 22 | 7 | |||
GHI | 32 | GHI | 32 | 4 | |||
GHI | 30 | GHI | 30 | 5 |
Advise me how to do this.
what I use measure or create new column.
regards,
NICK
Solved! Go to Solution.
You can add a new calculated column using the following formula.
New Column = RANKX( FILTER('Table1', 'Table1'[Sub]=EARLIER('Table1'[Sub]) ), 'Table1'[Value] )
You can add a new calculated column using the following formula.
New Column = RANKX( FILTER('Table1', 'Table1'[Sub]=EARLIER('Table1'[Sub]) ), 'Table1'[Value] )
Hi @Phil_Seamark,
Thanks for fast reply.
it's working with small issue.
it's giving same no. for duplicate data.
Note:- Change few data to show you result.
any advise for that.
Regards,
NICK
Hi @Naveennegi119,
Actually, current power bi will rank duplicate records as same ranking number.
AFAIK, power bi not contains row index and column index, so it is impossible to ranking duplicate records as different numbers.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |