Forum Discussion
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 precisa seguir o número máximo de "qtd venda".
Obrigado,
7 Replies
Oi Anonymous,
você poderia fornecer uma captura de tela da visualização desejada? Isso não é óbvio do que você tem o que você está tentando alcançar.
Obrigado,
John
Sorry for that.
I need the Index follow the MAX of sales amount.
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,
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)-1The 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.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,Hi, Anonymous ；
So you need to sort value first, and then add the index column.
I don't quite understand what you mean, if you can, can you share a simple file and want the output to show the results?
How to upload PBI in Community
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.
