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

SchmidMatt84's avatar
SchmidMatt84
New Member
1 year ago

Hi. Thanks! I've inlcuded an extract from the data in my earlier response. I use field parameters to let the user select different measures. 

FBergamaschi's avatar
FBergamaschi
Super User
1 year ago

I replied with the measure code but in order to do more if this is not enough I need the pbix with the field parameter at work

 

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

me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

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