Forum Discussion

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost 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
Icon for Solution Sage rankSolution 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
Icon for Post Prodigy rankPost Prodigy
5 years ago

I have tried to rephrase. please have a look.

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity 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!