Forum Discussion
Calculate Difference between multiple rows in table
Hi I have a table with two columes, Month and Value. I want to create a third column that calculate the difference between the first value (lowest date) and current value. The measure must be ...
Tahreem24
Super User
Super UserAnonymous Use the below Column:
Column =
VAR Prev = CALCULATE(SUM(MyTable[Value]),FILTER(ALL(MyTable),MyTable[MonthYear]=MIN(MyTable[MonthYear])))
RETURN MyTable[Value]-Prev