Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Accumulated With Percentage

    Posted 20 days ago
    Hello

    I need the current accrual by adding the current value to the previous accrual multiplied by a growth rate:
    X_Acum = X + (X_Acum previous year * (1 + Rate_Growth_Y))

    To illustrate, the attached yellow excel column shows the obtained value.

    Excel here

    ------------------------------
    Vilmar Santos
    ------------------------------


  • 2.  RE: Accumulated With Percentage

    Posted 17 days ago
    help please


    ------------------------------
    Vilmar Santos
    ------------------------------



  • 3.  RE: Accumulated With Percentage
    Best Answer

    Bronze Contributor
    Posted 5 days ago
      |   view attached
    Hi,
    You can find a solution in the attached file.
    If this solution is what you are looking for, please mark it as a Best answer.

    ------------------------------
    Hoss Satour
    Data analyst
    Algiers - DZ
    numidiabi.wordpress.com
    ------------------------------

    Attachment(s)

    pbix
    Help Vilmar Santos.pbix   19 KB 1 version