Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

YOY%

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

 

Need Help

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago
    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
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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