Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Index Calculated columns

Hi I need to add the calculated index column to the table by a DAX formula. Rgds Henrik

Anonymous
6 years ago
Hi Anonymous,

It seems like a multiple column sort recruitment, maybe you can take a look at following thread about using isonorafter to sort multiple columns:

Sorting by multiple columns

Regards,

Xiaoxin Sheng

Community Champion

6 years ago

Hi Anonymous

Try a column

Index = 
RANKX (
FILTER('Table','Table'[A] = EARLIER('Table'[A])),
'Table'[KEY]
)

Syndicate_Admin
Administrator
4 years ago
it works perfectly. Thanks.