Forum Discussion
pedroluccas
3 years agoFrequent Visitor
DYNAMIC INDEX WITH RANKX - SLICERS
Hello! I am working with a data series that relates a "result" (pH, mass, etc) to "sample code" and, in order to calculate my intersect, slope and R² I need an index starting with 1 But when I f...
v-xiaotang
3 years agoCommunity Support
Hi pedroluccas
Thanks for reaching out to us.
>> Is there a way to rank them in a way that every sample has a different number, in ascending order, according to date and that restarts the count with my slicers selection?
could you share a sample .pbix file that fully covers your question, including the slicers.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
pedroluccas
3 years agoFrequent Visitor
Hi, v-xiaotang
https://drive.google.com/file/d/1w7qID-TgUBzum14X1WRQXmZn-VYmyc4Z/view?usp=sharing
I attached a Drive link since I am not able to upload a .pbix file (seems that new users have restrictions)
Thank You