Forecasting Price - fixed and variable periods


I’m trying to create a field in my price forecasting model that flags whether the month’s price is fixed or variable to changes in certain variables.


We are currently in August, and are required to forecast price from September 2020 to June 2021. The first 3 months are fixed (a base price), with the remaining period’s to change based on certain variables.
I’m trying to allocate a flag to the 3 fixed months, so that i can use it as a filter when applying the logic.

I feel like this should be simple to do and yet everything I have tried has failed. My gut says to build it into my date table, but not sure how.

Any help or guidance would be greatly appreciated.

Murphy’s Law, I have found a solution:

I added a custom column to my date table.

You could leave out the date.addmonths, but this provides a bit of flexibility if you want your starting point to be different to the current month.

I hope this is helpful to someone :slight_smile: :grin: