table with compound interest in dax

Hi jgachon ,

 

You can reproduce the Excel-style compound interest table in Power BI using the following DAX to create a calculated table. This avoids circular references by computing each row using the compound interest formula directly:

CapitalTable =
VAR InterestRate = 0.025
VAR InitialCapital = 10000
VAR Years = GENERATESERIES(1, 10, 1)

RETURN
ADDCOLUMNS (
    ADDCOLUMNS (
        Years,
        "capital de départ",
            VAR YearNum = [Value]
            RETURN
                InitialCapital * POWER(1 + InterestRate, YearNum - 1),
        "intérêts",
            VAR YearNum = [Value]
            RETURN
                InitialCapital * POWER(1 + InterestRate, YearNum - 1) * InterestRate,
        "performance", "2.50%"
    ),
    "Année", [Value]
)

This will generate the full 10-year table with capital, interest, and fixed performance rate using DAX.

 

 

Best regards,