Compound Growth Rate for Month wise

Question

I have the few years Data from 2021 to 2025 .&nbsp; Every year have QTY month wise . i&nbsp; want find&nbsp; compund growth for month wise . i used below formula for Years in Excel . i want to convert to Month.&nbsp;Syntax:((currentyear)/(previousyear))^(1-n))-1&nbsp;LIke :&nbsp;((Currentmonth)/(PreviousMonth))^(1-n))-1&nbsp;QTY&nbsp; &nbsp;Month&nbsp; &nbsp;year10&nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp;202120&nbsp; &nbsp; &nbsp; &nbsp;Feb&nbsp; &nbsp; &nbsp; 202130&nbsp; &nbsp; &nbsp; &nbsp;Mar&nbsp; &nbsp; &nbsp; 202140&nbsp; &nbsp; &nbsp; &nbsp;Apr&nbsp; &nbsp; &nbsp; &nbsp;2021&nbsp;-----&nbsp;---21&nbsp; &nbsp; &nbsp; &nbsp; Dec&nbsp; &nbsp; &nbsp; 2025&nbsp;Looking for support .. thanks in advance&nbsp;

freemanz · Accepted Answer

hi&nbsp;Anonymous&nbsp;supposing you have a table like:YearMonthQty20229120221022022113202212420231520232620233720234820235920236102023711202381220239132023101420231115202312162024117&nbsp;1) add a calculated column like:&nbsp;MonthSN = ([Year]*12+[Month])&nbsp;2) plot a slicer with a calculated table like:&nbsp;n = 
SELECTCOLUMNS(
    GENERATESERIES(1,20),
    "n", [Value]
)&nbsp;3) plot a table visual with year and month column and a measure like:&nbsp;CMGA% = 
VAR _currentmonthSN = MAX(data[MonthSN])
VAR _n = SELECTEDVALUE(n[n])
VAR rate =
    DIVIDE(
        SUM(data[value]),
        CALCULATE(
            SUM(data[value]),
            ALL(data),
            data[MonthSN]=_currentmonthSN-_n
        )
    )^(1/_n)
    -1
RETURN
    IF(rate&lt;&gt;-1, rate, "")&nbsp;it worked like:&nbsp;

Forum Discussion

Compound Growth Rate for Month wise

2 Replies

Related content

growth % over month on month

Investment growth

Help with calculating Compound monthly growth rate

Compound Values

2YR CAGR - Compound Annual Growth Rate

Year	Month	Qty
2022	9	1
2022	10	2
2022	11	3
2022	12	4
2023	1	5
2023	2	6
2023	3	7
2023	4	8
2023	5	9
2023	6	10
2023	7	11
2023	8	12
2023	9	13
2023	10	14
2023	11	15
2023	12	16
2024	1	17