Forum Discussion

jaswalsarthak's avatar
jaswalsarthak
Frequent Visitor
1 year ago

CAGR * Columns

Hi All, i have 5 years of data & have got Dynamic CAGR (% format) into my Dashboard. Now i want to multiply this CAGR with my table. i am using the below formula.   CAGR Sale = SUMX(Table1,Table1[...
Need Help
jaswalsarthak's avatar
jaswalsarthak
Frequent Visitor
1 year ago

Hi I am not looking to calculate CAGR, that i have already done, i want to multiply CAGR with my table & that is not working.

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    Hi jaswalsarthak - Ok, then make sure your CAGR value is correctly calculated as like below:

     

    CAGR Value =
    (
    (SUM(Table1[Value]) / FIRSTNONBLANK(Table1[Value], 0)) ^
    (1 / COUNTROWS(DISTINCT(Table1[Year])))
    ) - 1

     

     

    If CAGR Value is a measure and not a column, you would need to modify the calculation

    CAGR Sale =
    SUMX(
    Table1,
    Table1[Value] * [CAGR Value]
    )

     

    Hope this helps.