Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

sum with the next value

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 )
)
 
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

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

     

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago
    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
  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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's avatar
    Ashish_Mathur
    Super User
    6 years ago

    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.