Forum Discussion

batuhanbilgin3's avatar
batuhanbilgin3
New Member
3 years ago
Solved

How to calculate difference between last year for the same category?

I'm new user in powerbi and need help. Table named techniquee and has 3 columns in power bi. First column is Integer. How can I calculate the difference of each technique compared to the previous year? Result should be in Difference columns name.

YearTechniqueValueDifference(result column)
2000Agile00
2000Devops20
2001Agile1010
2001Devops1513
2002Agile5040
2002Devops8065
Need Help
  • batuhanbilgin3's avatar
    batuhanbilgin3
    3 years ago
    I found this and it works. Thank you FreemanZ.
     
    Difference =
    VAR current_technique = techniquee[Teknik]
    VAR current_year = techniquee[Yıl]
    VAR prev_year_value =
        CALCULATE (
            SUM ( techniquee[Deger] ),
            FILTER (
                techniquee,
                techniquee[Teknik] = current_technique &&
                techniquee[Yıl] = current_year - 1
            )
        )
    RETURN
        IF( ISBLANK(prev_year_value), 0, techniquee[Deger] - prev_year_value )

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    hi batuhanbilgin3 

    try like:

    DifferenceColumn =

    VAR _valuepre =

    MAXX(

        FILTER(

            Technique,

            Technique[Technique]=EARLIER(Technique[Technique])&&Technique[Year]<EARLIER(Technique[Year])

        ),

      Technique[Value]  

    )

    RETURN

    [Value] - _valuepre

    • batuhanbilgin3's avatar
      batuhanbilgin3
      New Member
      3 years ago
      I found this and it works. Thank you FreemanZ.
       
      Difference =
      VAR current_technique = techniquee[Teknik]
      VAR current_year = techniquee[Yıl]
      VAR prev_year_value =
          CALCULATE (
              SUM ( techniquee[Deger] ),
              FILTER (
                  techniquee,
                  techniquee[Teknik] = current_technique &&
                  techniquee[Yıl] = current_year - 1
              )
          )
      RETURN
          IF( ISBLANK(prev_year_value), 0, techniquee[Deger] - prev_year_value )