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.
Dear friends
please guide me how can i create calculated index column that show ascending number based on value column like attached in data interfaces.
Name | Value | Index |
a | 10 | 2 |
b | 10 | 1 |
a | 5 | 1 |
b | 15 | 2 |
b | 20 | 3 |
c | 10 | 2 |
c | 5 | 1 |
a | 15 | 3 |
Solved! Go to Solution.
@Anonymous , Create a new column like
countx(filter(Table, [Name] = earlier([Name]) && [Value] <= earlier([Value])),[Value])
@Anonymous ,
Try this column:
@Anonymous ,
Please see a below Screen shot with output:
Hi @Anonymous
Try this
Column =
VAR __name = 'Table'[Name]
VAR __tbl = FILTER( 'Table', 'Table'[Name] = __name )
RETURN
RANKX( __tbl, 'Table'[Value],, ASC )
@Anonymous ,
Please see a below Screen shot with output:
@Anonymous ,
Try this column:
@Anonymous , Create a new column like
countx(filter(Table, [Name] = earlier([Name]) && [Value] <= earlier([Value])),[Value])
Thanks you @amitchandak and @Tahreem24 for quick reply boths are worked correctly!!!
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |