Forecasting Price - fixed and variable periods

Hi,

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.

Example:

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.
Regards,
Bronwyn

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: