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...
Do you have a "order by" column for the table? OFFSET need a order of the values.
I ended up changing the table to not contain the date and calculate with filter:
Var em % =
VAR _MAX = maXX('Date','Date'[Ano])
VAR _MIN = MINX('Date','Date'[Ano])
RETURN
100*(CALCULATE([Sum Values],FILTER(ALLSELECTED(Ranking[Date]),YEAR(Ranking[Date])=_MAX))/ CALCULATE([TSum Values],FILTER(ALLSELECTED(Ranking[Date]),YEAR(Ranking[Date])=_MIN))).
It's not perfect as I had to add the meausure as a column, but I can hide and the end visual seems to be fine