Forum Discussion
Vladracs
Helper I
Helper IDivide 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...
VladracsHelper I
Helper IHi I am trying to understand how can I create a index that is "dynamic" meaning it will change based on the slicer.
If I add a fixed item column , when I filter the formulas above dont reflect what I need as they will still show an entry that is not on the filtered (sliced) table at the final page 😕
Padycosmos
Solution Sage
Solution SageWell. instead of index, you can try creating a Rank. These 3 videos can give you an idea:
https://www.youtube.com/watch?v=3IHsIngGdjU
- Vladracs
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 😕