Forum Discussion

ModernAchilles's avatar
7 years ago

Time Intelligence for substituting Blank days in a Month Forward

Hi,

 

I've been trying to find a solution for the days in the month that are blank.

 

I have created a last 7 Day moving average that I want forecasted out for the rest of the month. I'd like this by day to create a visual.

 

What I'd like is that the Net Revenue Coloumn gets populated with that $5,457 Number for the rest of the month. 

 

 

 

Here is the formula for the 7-day Moving Average:

 

  

 

I'm having a problem Forecasting the rest of the days in the month based off a single calculation too.

 

This Table I have one Calculation I want to populate in the rest of the days in the month. Where I'd like the Budget Daily Reveune $5900 to populate the rest of the days in the month. 

 

 

 

 

 

 

I was thinking something like this, but not sure. 

 

 

 

Thanks for all the help! :)