Forum Discussion

DavidB's avatar
DavidB
Frequent Visitor
9 years ago

Moving average measure with sum

Hello I am new to this forum and calculated formulas in general - so bear with me if the question is 'too easy' :)   I have a simple data set like this example "FRUIT":    DATE ITEM COUNT...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi DavidB,

For 2017-01-01, you don't want to get (10+34+20)/3, you need to the past month's(2016/12/1-2016/12/31) average? But there is no past month's data. Could you please create some fake sample table, and list the desired result, so that we can post solution which is close to your needs. Thanks for understanding.

Best Regards,
Aneglia

DavidB's avatar
DavidB
Frequent Visitor
9 years ago

Hello v-huizhn-msft

 

Thank you for taking your time to help. I understand what you mean, but there will always be a starting point in the dates, that do not have a previous month. What Excel does, is just not make a trendline before a full set of one month data is present, so it looks like this:

 

 

So if I have a dataset consisting over 6 months, the moving average will be present on the previous 5 months.

If you still want a fake sample table, I can certainly make that.

    • DavidB's avatar
      DavidB
      Frequent Visitor
      9 years ago

      Bump
      (don't know if this is allowed) :)

       

      Edit: To sum it up. I wan't to make the moving average of the sum of the dates - disregarding the fruit (column B).

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi DavidB,

        You'd better open a new thread if you have new problems. There is one problem in one case, thanks for understanding.

        Best Regards,
        Angelia