How to calculte year on year difference

[Ptolemaida]

I have a table like this:

Contract	Date	Revenue
1	1/08/2025	100
2	1/05/2024	20
2	1/05/2025	80
1	1/04/2024	50
3	1/04/2025	50

I want to calculate the difference between this year (2025) and last year (2024), using my filters. For example only for the period jan-july

Result should look like this (if filter month = 1 - 7)

Contract	YoY
1	-50
2	60
3	50

Please need help with DAX Measure. thanks.

[v-hashadapu · Accepted solution]

Hi @Ptolemaida , Thank you for reaching out to the Microsoft Community Forum.

We find the answer shared by @Cookistador  is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.

Thank you @Cookistador  for your valuable response.

[Shubham_rai955]

You can do this easily with a YoY (Year-over-Year) DAX measure like this:

 

YoY Revenue = VAR CurrentYear = YEAR(MAX('Table'[Date])) VAR LastYear = CurrentYear - 1 VAR RevenueThisYear = CALCULATE( SUM('Table'[Revenue]), YEAR('Table'[Date]) = CurrentYear ) VAR RevenueLastYear = CALCULATE( SUM('Table'[Revenue]), YEAR('Table'[Date]) = LastYear ) RETURN RevenueThisYear - RevenueLastYear

Important notes:

1. Make sure you have a Date table properly marked as a date table.

2. When you filter (for example, months 1–7), the measure will respect that automatically.

3. Place Contract on rows and this YoY Revenue measure on values

[KarinSzilagyi]

Hi @Ptolemaida, try this measure 

Contract YoY = 
VAR CurrentYear =
    MAXX (
        ALLSELECTED (Contracts[ContractDate]),   
        YEAR (Contracts[ContractDate])
    )

VAR ThisYearRevenue =
    CALCULATE (
        sum(Contracts[Revenue]),
        FILTER (
            ALLSELECTED (Contracts[ContractDate]),
            YEAR (Contracts[ContractDate]) = CurrentYear
        )
    )
VAR LastYearRevenue =
    CALCULATE (
        sum(Contracts[Revenue]),
        FILTER (
            ALLSELECTED (Contracts[ContractDate]),
            YEAR (Contracts[ContractDate]) = CurrentYear - 1
        )
    )
RETURN 
    ThisYearRevenue - LastYearRevenue

[Cookistador]

Hi @Ptolemaida 

The first step is to create a date table: to do that, create a calculate table with calendarauto()
You link your date table and the table in which you have the revenue and then, you just have to create the following measure:

Delta Revenue =

Var RevenueLY =

CALCULATE(

    SUM(Data[Revenue]),

    SAMEPERIODLASTYEAR('Date'[Date])

)

VAR RevenueCY =

SUM(Data[Revenue])

RETURN

 RevenueCY - RevenueLY

Replace Data by the name of the table in which you have the data related to the revenue, and this the result you should have: