Forum Discussion
Substract row to another row on the same column without creating new column
I have a quite interesting request. I have a table like this one: Type Year Price Value1 Value2 Value3 Home 2021 9 2 3 4 Home 2022 27 5 6 7 Home 2023 42 4 5 6...
Depso dos this work?
MEASURE =
VAR base =
FILTER ( ALL ( tbl ), tbl[Year] <= MAX ( tbl[Year] ) )
VAR grp =
VALUES ( tbl[Type] )
RETURN
CALCULATE ( SUM ( tbl[Value1] ), base, grp )
+ CALCULATE ( SUM ( tbl[Value2] ), base, grp )
+ CALCULATE ( SUM ( tbl[Value3] ), base, grp )
Unfortunatelly, no.
I need it to reference automatically the previous item in the same column like in the screenshot example below:
It should be based on the year.