Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help with conditional index

Oi pessoal!    Eu preciso de uma ajudinha com um problema de índice. Quero criar um índice condicional baseado na coluna "qtd venda" (see the anex).  Basicamente, o primeiro número do índice...
Need Help
Tips and Tricks
Tutorial Requests
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, Anonymous ;

You could add index column in power query.

Sort first.

add index column next.

Or in desktop create a column by dax.

Index2 = RANKX('Table',[qtd],,DESC)-1

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

v-yalanwu-msft,

First, thanks for helping. 

Sorry for not being clear. 

I tried solve this using the sort function, but if the "qtd venda" (sales amount) number change position, the index will follow.

Lets use this table:

 

If the sales amount of any cod change, the index will move, even if i sort the column and the table will do that:

But i need this:

 

Index 1 must always be linked to the highest sales amount. I tried with RANKX but when sales amount of two lines has the same value, the rank number is the same for both, even using dense function. 

I hope it was more clearer.

Thanks,