Forum Discussion
Help with conditional index
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.
Hi, Anonymous ;
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
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.