Forum Discussion

Dunner2020's avatar
Dunner2020
Post Prodigy
5 years ago
Solved

Calculating predicted value

I am trying to show the predicted value of upcoming months based on the average of last 5 values. The regulatory year starts in April and Finishes in March. The way I am calculating forecast value i...
Need Help
Show and Tell
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Dunner2020 ，

     

    It's not very clear about your requirement based on the sample .pbix you provided:

    So which result is not the one you wanna get?Can you explain more detailed according to your sample data?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

daxer-almighty's avatar
daxer-almighty
Solution Sage
5 years ago

Hi Dunner2020 

 

I don't think this is a very complex task... but the description is a bit lacking in my opinion. This makes it harder than it should be to find the right solution. Could you please rephrase your narrative and make it clearer?

  • Dunner2020's avatar
    Dunner2020
    Post Prodigy
    5 years ago

    I have tried to rephrase. please have a look.

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

      Hi Dunner2020 ,

       

      Is your issue solved now?If so,could you pls mark the reply as answered to close it?

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!