Forum Discussion
Help with conditional index
Community SupportHi, 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,- v-yalanwu-msft
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.Hi v-yalanwu-msft,
I did it using this way of sorting, the problem is the problem is that this dataset will be fed in the future, I started to realize that performing this task in powerquery using index will not work.
I need to sort the ''cod prod'' by indexes based on sales amount and if that value changes, the highest value will always be index 1. Basically, it's a rank in DAX, where the highest value will always be rank 1 and so on. But I have several products that have the same sales numbers and rankx doubles the position of these products even using rankx dense.