Forum Discussion
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 rev...
ValtteriN
Community Champion
Community ChampionHi,
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!
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!