Time Projection - 5 Years
Hello Everyone. I would like to prepare measures that will allow me to create so-called projections for the future based on historical data. Currently I have: - a base month from which I want to start calculations ( 2022-01 ) - the current indicator, which is updated daily - the % growth rate, which represents whether the trend is upward or not, to calculate this I used the following measure: Growth Rate % = DIVIDE(Capacity_FTE_Total[Capacity_FTE], HIST_CAPACITY[History FTE]) - 1 Now I would like to create a measure that, based on the change that occurred between the base month and the current rate, will predict what " Capacity will have in 2023-01. Based on the result of 2023-01, it will predict what the result ratio will be in the following year, etc. etc. ( forecast up to a maximum of 5 years ). Is it possible to create this type of measures in Dax ? Regards Piotr.
