Forum Discussion
Divide 2 values on the same column?
Do you have a "order by" column for the table? OFFSET need a order of the values.
- Vladracs3 years agoHelper I
Actually there is another column that determine the order...but I was trying to avoid showing it as it is a date (year), the table is filtered by date, and then I start getting these replies around using date formulas... and that doesnt do the job... see my previous post: https://community.powerbi.com/t5/Desktop/Find-growth-between-2-rows-after-filtering-a-table/td-p/3117372
- Vladracs3 years agoHelper I
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