Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Trailing 12 Month Average

I have this table:

 

And I've attempted to create a formula that calculates the trailing 12 month average for the net promoter score, but I think it's just doing a normal average. Here is that formula:



Which in turn gives me this graph:

This seems like it could be correct, but how do I ensure it's calculating trailing 12 month average and not just the average?

 

Thanks!

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • afzalphatan's avatar
    afzalphatan
    8 years ago

    Hi,

     

    Use DATEADD( ) function.... this is the best choise for your requirement..

     

    Regards

    Afzal khan

3 Replies

  • afzalphatan's avatar
    afzalphatan
    Resolver I
    8 years ago

    Hi,

     

    Use DATEADD( ) function.... this is the best choise for your requirement..

     

    Regards

    Afzal khan

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous, 

     

    1. Can you share a dummy sample please?

    2. Is the concept of trailing 12 month average as follow?

    2018-01        monthly average of 2017-02 to 2018-01

    2018-02        monthly average of 2017-03 to 2018-02

    2018-03        monthly average of 2017-04 to 2018-03

    ... ...

     

    3. What's in the x-axis? Year or year-month?

    4. I guess your result is incorrect.

     

    Best Regards,

    Dale