Creating compounding revenue table

[slatta33]

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!

[slatta33]

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!

[ValtteriN]

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!

[slatta33]

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!