Forum Discussion

Dandeats's avatar
Dandeats
Frequent Visitor
5 years ago

Project forward YTD average and rolling average

Hi this is my first post 🙂   I'm working on a report where I give the users multiple forward scenarios based on costs incurred historically. They can then compare the values vs. their own forecast...
Need Help
Dandeats's avatar
Dandeats
Frequent Visitor
5 years ago

Hi just to follow up - I prepared a simpler PBIX file which hopefully you can access from here ... 

 

What I would like to do is to fill in the remaining months for scenario 3 and 4 by projecting forward / using the YTD avg and rolling avg respectively ... the desired output would look something like this ... and the series be "summable" ...

 

Hoping someone can help 🙂 Thank you

 

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Dandeats ,

     

    Do you mind providing a sample .pbix file?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.