Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Creating compounding revenue table

Hello,  

 

I am trying to create a compounding revenue table that is linked to a single value parameter.  For example,  

 

 

I would like to select from the parameter percent change in revenue so that it will effect the table dynamically.  I was able to create it in excel, but cannot seem to figure out the DAX to make this run.  Thank you for the help!

3 Replies

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi,

    It is possible to do this in a table but I wouldn't recommend this since measures should do everything you need to do here. E.g.

    Test data:


    Dax (first add a parameter for rate):



    New value = SUM(Compound[Value])*(1+[Compound Value])



    End result:

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!




    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello,

       

      Thank you for the response.  The 2 items I need to add to the dax you provided is that it filters by year and provides a unique value for each year, then it is added.  

       

       

       

       

      Thank you!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello,

     

    Thank you for the response.  The 2 items I need to add to the dax you provided is that it filters by year and provides a unique value for each year, then it is added.  

     

     

     

    Thank you!