sum with the next value

[Anonymous]

hello everyone , i need help with this, i am new in this 

i need next row - row

i have this but is wrong

testc =

VAR LAST =

CALCULATE (

max( 'ENE 2020'[Index]);

'ENE 2020';

'ENE 2020'[DETALLE MAQUINARIA] = EARLIER ( 'ENE 2020'[DETALLE MAQUINARIA] );

'ENE 2020'[Index] < EARLIER ( 'ENE 2020'[Index] )

) +0

RETURN

IF (

LAST = 0;

'ENE 2020'[HORÓM.];

'ENE 2020'[HORÓM.]

- CALCULATE ( SUM ( 'ENE 2020'[HORÓM.]); 'ENE 2020'; 'ENE 2020'[Index] = LAST )

)

[amitchandak · Accepted solution]

@Anonymous ,Try as New columns

next date = Minx(filter('ENE 2020',[DETALLE MAQUINARIA] = EARLIER ([DETALLE MAQUINARIA] ) && [FECHA] > EARLIER ([FECHA] ) ), [FECHA])
next Value = Minx(filter('ENE 2020',[DETALLE MAQUINARIA] = EARLIER ([DETALLE MAQUINARIA] ) && [FECHA] =EARLIER ([next date] ) ), [HOROM])

[Ashish_Mathur]

Hi,

If the numbers i the third column are always in ascending order (as is the case in your example), then try this calculated column formula

=Calculate(min('ENE 2020'[HORÓM.]),filter('ENE 2020','ENE 2020'[DETALLE MAQUINARIA]=earlier('ENE 2020'[DETALLE MAQUINARIA])))-'ENE 2020'[HORÓM.]

Hope this helps.

[lbendlin]

Measure =

var d=SELECTEDVALUE('Table'[Date])

var n = CALCULATE(min('Table'[Date]),'Table'[Date]>d)

var r= CALCULATE(sum('Table'[Value]),'Table'[Date]=n) - sum('Table'[Value])

return r