Forum Discussion

jgreutert's avatar
jgreutert
Regular Visitor
5 years ago
Solved

Calculation between rows

Hi Everybody, I would like to make calculations between row. Es. COD.    DESC.     VAL      1           A          5      2           B          3      3           C    NULL I would like to put...
  • jgreutert's avatar
    jgreutert
    5 years ago

    Hello,

    I found the solution that I wanted. I post her in case can be useful for someonelse.

    I created a misure VALUE BIS

    VALUES BIS =

    VAR CURRENT_ROW=SELECTEDVALUE(TABLE[ID])

    VAR ROW3=CALCULATE(SUM(VALUE),FILTER(ALL(TABLE),TABLE[ID]=1))-CALCULATE(SUM(VALUE),FILTER(ALL(TABLE),TABLE[ID]=2))

    RETURN
    SWITCH(CURRENT_ROW,3,ROW3,SUM(VALUE))

     

    Best regards

amitchandak's avatar
amitchandak
Super User
5 years ago

jgreutert , Try like. But logic is not extendable

maxx(filter(table,[COD] = earlier([COD]) -2),[VAL]) - maxx(filter(table,[COD] = earlier([COD]) -1),[VAL])

jgreutert's avatar
jgreutert
Regular Visitor
5 years ago

Is it possibile to do it as misure?

Many thanks for the useful answers!!

  • jgreutert's avatar
    jgreutert
    Regular Visitor
    5 years ago

    Hello,

    I found the solution that I wanted. I post her in case can be useful for someonelse.

    I created a misure VALUE BIS

    VALUES BIS =

    VAR CURRENT_ROW=SELECTEDVALUE(TABLE[ID])

    VAR ROW3=CALCULATE(SUM(VALUE),FILTER(ALL(TABLE),TABLE[ID]=1))-CALCULATE(SUM(VALUE),FILTER(ALL(TABLE),TABLE[ID]=2))

    RETURN
    SWITCH(CURRENT_ROW,3,ROW3,SUM(VALUE))

     

    Best regards