Forum Discussion

Aleiadeh's avatar
Aleiadeh
Frequent Visitor
5 years ago

Difference between rows and keep first row value

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 val...
amitchandak's avatar
amitchandak
Super User
5 years ago

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