Forum Discussion
Helper ITime Projection - 5 Years
See attached for a pedestrian implementation. It includes a calendar table even though that is not strictly required.
Helper IHi.
I think that maybe be a solutions for me.
Could you help me to create the code that will calculate this, based on my previous calculations.
Regards Piotr
Super UserPlease provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
- piotrgrendus87
Hello, below is a sample of the data
Start Point ( January 2022 ) Current Point ( August 2022) Growth Rate % January 2023 January 2024 January 2025 January 2026 1952 2006 2,77% 2011 2040 2050 2060 259.5 256.5 -1,16% 250 260 270 285 348 406 16,67% 410 420 450 470 First 3 columns - Calculation based on the data
Last 4 columns - Manually sample data as expected result
I want to create a calculation that based on the value of " Growth Rate % " will calculate my probable result in 2023, while based on the value of 2023 will calculate my result for 2024, and so on and so forth. The only value that will change daily is " Current Point ", since it will be updated daily and its change should also be reflected for the values for 2023, 2024, 2025, 2026. " Start Point ", will be set once a year and will not change during the 12 months. I don't know if my approach to the topic is correct or not ?, maybe it will just be simpler to use the built-in forecasting model that is in PowerBi.
Regards Piotr
- lbendlin
See attached for a pedestrian implementation. It includes a calendar table even though that is not strictly required.