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!

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!