Forum Discussion
Divide 2 values on the same column?
Hello Expert, I am still trying to solve this problem, which I probably should have explained in a better way. Is there a way to dynamicaly calculate the variance between 2 row in a column, e...
Well. instead of index, you can try creating a Rank. These 3 videos can give you an idea:
https://www.youtube.com/watch?v=3IHsIngGdjU
Thanks for the hint on rankx, I can use it well to create ranks, but doesnt help me solve the original problem. It's crazy as this is a simple math dividing 2 rows...but in powerbi and dynamic tables, it seems like a lot of hassle 😕