Forum Discussion

SchmidMatt84's avatar
SchmidMatt84
New Member
1 year ago
Solved

Calculation of difference between two rows

Hi I need to calcualte the difference between two values which is different depending on a "version"-Value. If its the version "Basis" the difference should be calculated bewtween the years (eg. 202...
  • FBergamaschi's avatar
    FBergamaschi
    1 year ago

    I think a visual calculation here would be the best approach anyway so I try to solve it immediately using the names in the visual picture you sent

     

    Difference Visual CALC =
    VAR MinYear = MINX ( ROWS, [Jahr] )

    VAR CurrentYear = [Jahr]
    RETURN

    IF (
          [Variante] = "Basis" && CurrentYear <> MinYear && ISATLEVEL ( [Jahr] ), 

          [DVE]- CALCULATE ( [DVE], [Jahr] = CurrentYear -1 ),
          [DVE] - CALCULATE ( [DVE], [Variante] = "Basis" )
    )

     

    If you need to reuse this concept you need a regular measure, in that case refer to my previous post to provide some data

     

    If this helped, please consider giving kudos and mark as a solution

    mein replies or I'll lose your threadconsider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

FBergamaschi's avatar
FBergamaschi
Super User
1 year ago

My solution with measures

 

Wert Value = SUM ('10_Total_Merge'[Wert] ) this is the measure I am referring
 
Wert Delta =
VAR _Variante = SELECTEDVALUE( '90_Version'[Variante] )
VAR CurrentYear = SELECTEDVALUE( '90_Version'[Jahr] )
VAR MinYear = CALCULATE( MIN ( '90_Version'[Jahr] ), REMOVEFILTERS( ) )
RETURN
IF (
      _Variante = "Basis" && CurrentYear <> MinYear && ISINSCOPE( '90_Version'[Jahr] ),
      [Wert Value]- CALCULATE ( [Wert Value], '90_Version'[Jahr] = CurrentYear - 1 ),
      [Wert Value] - CALCULATE ( [Wert Value], '90_Version'[Variante] = "Basis" )
)
 

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your threadconsider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI