Create ascending index column by DAX based on row values

[Anonymous]

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

[amitchandak · Accepted solution]

@Anonymous , Create a new column like

countx(filter(Table, [Name] = earlier([Name]) && [Value] <= earlier([Value])),[Value])

[Tahreem24 · Accepted solution]

@Anonymous ,

Try this column:

index =

RANKX (

FILTER (

Sheet4,

EARLIER ( Sheet4[Name] ) = Sheet4[Name]

), Sheet4[Value],,

ASC

)

[Mariusz]

Hi @Anonymous 

Try this 

Column = 
VAR __name = 'Table'[Name]
VAR __tbl = FILTER( 'Table', 'Table'[Name] = __name )
RETURN 
RANKX( __tbl, 'Table'[Value],, ASC  )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Tahreem24 · Accepted solution]

@Anonymous ,

Please see a below Screen shot with output:

[Tahreem24 · Accepted solution]

@Anonymous ,

Try this column:

index =

RANKX (

FILTER (

Sheet4,

EARLIER ( Sheet4[Name] ) = Sheet4[Name]

), Sheet4[Value],,

ASC

)

[amitchandak · Accepted solution]

@Anonymous , Create a new column like

countx(filter(Table, [Name] = earlier([Name]) && [Value] <= earlier([Value])),[Value])

[Anonymous]

Thanks you @amitchandak and @Tahreem24 for quick reply boths are worked correctly!!!