Forecast for future period


#1

Hi, Sam,
Thanks all the training materials you have published. I’ve learned so much from them.

I am working on a power query forecast model.

I try to use last three months average as the amount for the future periods. I have difficult in using DAX function to populate the forecast amount against further period.

Any suggestion?

Thanks,
Jane


#2

Hi Jane,

That’s great.

Have you had a chance to go through some of these tutorials?

This one is about repeating a trend forward continuously.

Another one about forecasting forward here.

See how you go with these and let me know what formula you come up with. It will like be a combination of techniques from both of these.