Compound Growth Rate for Month wise

hi Anonymous 

supposing you have a table like:

1) add a calculated column like:

MonthSN = ([Year]*12+[Month])

2) plot a slicer with a calculated table like:

n = 
SELECTCOLUMNS(
    GENERATESERIES(1,20),
    "n", [Value]
)

3) plot a table visual with year and month column and a measure like:

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<>-1, rate, "")

it worked like: