Difference between rows and keep first row value

Question

Greetings,&nbsp;I am trying to add a calculated column or Measure that will return the difference of two rows of a MEASURE (Column B-A, C-B and so on) In the same time I need to keep the first row value (A) as it is.I tried with below command for calculated cloumn but the first row was wrong I need keep the result "134,685.68" for first column then calculate the difference :CC_Weekly_Actual_NLU =[M_Weekly_Actual_NLU-(CALCULATE([M_Weekly_Actual_NLU],FILTER(Actual_NLU,Actual_NLU[Index.1]=EARLIER(Actual_NLU[Index.0]))))&nbsp;&nbsp;Any suggestion to modify the Calculated Column or provide a new Measure formula to provide what I want.&nbsp;Thank you in advance

amitchandak · Answer

Aleiadeh , Try a new column like 
Column = var _1 = maxx(FILTER('Table', 'Table'[Date] &lt; EARLIER('Table'[Date])),LASTNONBLANKVALUE('Table'[Date],'Table'[M_Weekly_Actual_NLU]))
return [M_Weekly_Actual_NLU] -_1

Forum Discussion

Related content

Different schema into different destination

Page Level filter for different groups

Difference between different Staging lakehouses

Dynamic Calculation Different Period

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