Forum Discussion
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:
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.
See attached for a pedestrian implementation. It includes a calendar table even though that is not strictly required.
5 Replies
Sounds like you are looking for PRODUCTX ?
Hi.
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
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
