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
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
      Icon for Microsoft Employee rankMicrosoft 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