Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My data runs through 2018. I then have projected year over year growth percentages based on data in another table for 2019, 2020, 2021.
What I would like to do is take my amount from 2018 and apply the growth percentage for 2019 from my other table. Then for 2020, it should take the result of this measure and then apply the year over year growth percentage for 2020, etc..
So for example my amount for 2018 is $100. In another table, it says the year over year growth percentage for 2019 is 20%. So the result for 2019 should be (100 * 1.2) = 120. Then for 2020 the growth percentage is 5%. So it should take the result for 2019 ($120) and apply the 2020 growth percentage (120 * 1.05) = $126.
Any ideas on how to do this? I guess it would be similar to a compund interest calculation sort of.
Solved! Go to Solution.
I think this blog post answers my question:
https://blog.gbrueckl.at/2015/04/recursive-calculations-powerpivot-dax/
Thanks!
I think this blog post answers my question:
https://blog.gbrueckl.at/2015/04/recursive-calculations-powerpivot-dax/
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |