YOY%

[Himanshu_1306]

Hi All,

I'm stuck on an issue where my YOY% is not coming correct.

Calculation used: 

YOY % Churn Lost = DIVIDE(SUM(AGGR_LAND_EXPAND_VIEW[PLAN_CHURN_LOST]),CALCULATE(SUM(AGGR_LAND_EXPAND_VIEW[PLAN_CHURN_LOST]),SAMEPERIODLASTYEAR(AGGR_LAND_EXPAND_VIEW[DATE].[Date])))-1

Current Month End Number i.e Oct'2022 = ($5.54M)

Oct'2021 Number = ($3.15M)

So ideally the % change should be somewhere around 75% but not sure why my calculation showing it as 115%.

Any help here?

Regards,

Himanshu

[FreemanZ]

As Time Intelligence Function, SAMEPERIODLASTYEAR is supposed to take argument from Date columns from Date table. Supposing you already have a Date table, try to change the measure to:

 

YOY % Churn Lost =

DIVIDE(

    SUM( AGGR_LAND_EXPAND_VIEW[PLAN_CHURN_LOST]),

    CALCULATE(

        SUM(AGGR_LAND_EXPAND_VIEW[PLAN_CHURN_LOST]),

        SAMEPERIODLASTYEAR('Date'[Date])

    )

)-1

[Himanshu_1306]

No luck, its giving the same value i.e 115%.