Help with Dax measure/calculated column

Hi ,  Anonymous 

According to your description, you can try calculated column as below after creating a index:

Value = 
VAR m = [Index]
RETURN
    100
        * (
            SUMX (
                FILTER ( 'Table', [Index] >= 2 && [Index] <= m ),
                VAR i = [Index]
                VAR t =
                    FILTER ( ALL ( 'Table' ), [Index] >= i && [Index] <= m )
                RETURN
                    CALCULATE ( PRODUCTX ( t, [Rate] ) )
            )
                + CALCULATE ( VALUES ( 'Table'[Rate] ), FILTER(ALL('Table'),'Table'[Index] = 1 )
        ))

Here is a sample :

URL: https://wicren-my.sharepoint.com/:u:/g/personal/michael_wicren_onmicrosoft_com/EeRW33d2a0NMgZXo3yJhwYMBMI2oCGW9stq8HfdNHV8U-g?e=LaCV05

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.