Comparing Change in data in 2 time periods

Anonymous ,

Suppose past Period is 2 years ago and assume no other tables. You may create a measure using DAX like pattern below:

Changes in Average area size between time period =
VAR Current_Year =
    YEAR ( COMPANY[Date] )
VAR Present_Average_Area_size_per_meter =
    CALCULATE (
        [AVARAGE AREA SIZE OF TRANSACTED LAND],
        FILTER (
            ALLEXCEPT ( COMPANY, COMPANY[Meter] ),
            YEAR ( COMPANY[Date] ) <= Current_Year
                && YEAR ( COMPANY[Date] ) >= Current_Year - 1
        )
    )
VAR Past_Period_Average_Area_size_per_meter =
    CALCULATE (
        [AVARAGE AREA SIZE OF TRANSACTED LAND],
        FILTER (
            ALLEXCEPT ( COMPANY, COMPANY[Meter] ),
            YEAR ( COMPANY[Date] ) <= Current_Year - 2
                && YEAR ( COMPANY[Date] ) >= Current_Year - 3
        )
    )
RETURN
    ( Present_Average_Area_size_per_meter - Past_Period_Average_Area ) / Present_Average_Area_size_per_meter

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.