YOY Difference help

[gopu99]

Hi i have a data which will be refreshed timely

Tuition	account	Year
50	texas	2020-2021
100	texas	2021-2022
150	texas	2022-2023
200	penstate	2023-2024
250	penstate	2024-2025
300	perdue	2025-2026
350	perdue	2026-2027
400	perdue	2027-2028

i want to calculate the year on year change in Tuition Fee based on the Account 
i tried to create a date table but it didnt work 

Currently trying with this DAX Formula

YoY Growth =

VAR CurrentYearFee = SUM(Sheet1[Tuition ])

VAR PreviousYearFee =

    CALCULATE(

        SUM(Sheet1[Tuition ]),

        FILTER(

            ALL(Sheet1), (VALUE(Sheet1[ Year]) - 1)

        )

    )

RETURN

IF(ISBLANK(PreviousYearFee), 0, (CurrentYearFee - PreviousYearFee) / PreviousYearFee)
when i use this formul it is returning all 0 in all the rows
Please let me know any changes or things i can do to solve this thank you.

[Anonymous · Accepted solution]

Hi @gopu99 ,

You can update the formula of measure [YoY Growth] as below, and check if that is what you want.

YoY Growth = 
VAR _selaccount =
    SELECTEDVALUE ( 'Sheet1'[account] )
VAR _selyear =
    SELECTEDVALUE ( 'Sheet1'[Year] )
VAR CurrentYearFee =
    SUM ( Sheet1[Tuition] )
VAR _preyear =
    CALCULATE (
          MAX ( Sheet1[Year] ),
        FILTER (
            ALLSELECTED ( Sheet1 ),
            'Sheet1'[account] = _selaccount
                && 'Sheet1'[Year] < _selyear
        )
    )
VAR PreviousYearFee =
    CALCULATE (
        SUM ( Sheet1[Tuition] ),
        FILTER (
            ALLSELECTED ( Sheet1 ),
            'Sheet1'[account] = _selaccount
                && 'Sheet1'[Year] =_preyear
        )
    )
RETURN 
    IF (
        ISBLANK ( PreviousYearFee ),
        BLANK (),
        ( CurrentYearFee - PreviousYearFee ) / PreviousYearFee
    )

Best Regards

[gopu99]

@amitchandak