Difference between rows and keep first row value

Aleiadeh — Wed, 04 Nov 2020 07:38:04 GMT

Greetings,

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]))))

Any suggestion to modify the Calculated Column or provide a new Measure formula to provide what I want.

Thank you in advance

Re: Difference between rows and keep first row value

amitchandak — Wed, 04 Nov 2020 09:28:55 GMT

Aleiadeh , Try a new column like

Column = var _1 = maxx(FILTER('Table', 'Table'[Date] < EARLIER('Table'[Date])),LASTNONBLANKVALUE('Table'[Date],'Table'[M_Weekly_Actual_NLU]))

return [M_Weekly_Actual_NLU] -_1

topic Difference between rows and keep first row value in DAX Commands and Tips

Difference between rows and keep first row value

Re: Difference between rows and keep first row value