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

[batuhanbilgin3]

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.

Year	Technique	Value	Difference(result column)
2000	Agile	0	0
2000	Devops	2	0
2001	Agile	10	10
2001	Devops	15	13
2002	Agile	50	40
2002	Devops	80	65

[FreemanZ]

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 · Accepted solution]

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 )