Calculate Difference between multiple rows in table

Question

Hi&nbsp;I have a table with two columes, Month and Value.&nbsp;I want to create a third column that calculate the difference between the first value (lowest date) and current value.The measure must be dynamic since the dates is adjustable. (See below where desired result of difference is shown)&nbsp;I try using below dax for mindate but only recieve same date as selected row (e.g. 2302 at row 2302 when I want to recieve 2301 to be able to compare with this basevalue). Do I need to replace "Allselected" with somethingelse?CALCULATE(min('Date'[MonthSort]),ALLSELECTED('Date'[Date]))&nbsp;Example:YearMonth&nbsp; &nbsp;Value&nbsp; Difference2301&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp;0 (10-10)2302&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12&nbsp; &nbsp; &nbsp; &nbsp;2 (12-10)2303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-2 (8-10)&nbsp;2304&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11&nbsp; &nbsp; &nbsp; &nbsp; 1 (11-10)

coreyp · Answer

I think you need to use ALL.

anonymous · Answer

Hi&nbsp;CoreyP&nbsp;Unfortunately, that return the same result as Allselected&nbsp;

tahreem24 · Answer

Anonymous&nbsp;Use the below Column:

&nbsp;

Column =
VAR Prev = CALCULATE(SUM(MyTable[Value]),FILTER(ALL(MyTable),MyTable[MonthYear]=MIN(MyTable[MonthYear])))
RETURN MyTable[Value]-Prev
&nbsp;

&nbsp;

&nbsp;
&nbsp;

Forum Discussion

Calculate Difference between multiple rows in table

3 Replies

Related content

Dynamic Calculation Different Period

Different Calculations

Using Visual Calculation on a Calculated Group with Multiple Calculated Items

CALCULATE with multiple filters

1. How to add two different calculated columns of two different table