+ Reply to Thread
Results 1 to 3 of 3

Moving average using last and firstdate

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    594

    Moving average using last and firstdate

    In response to Richard Buttney, same questiong but I've attached the file, jus to not there are some
    Excel fromulas, but it's the diffence between first and last date in the measure gird that's of interest.


    < Moving X Month Avg:=CALCULATE(AVERAGE(MAT[Units]),
    DATESINPERIOD(MAT[Date],LASTDATE(MAT[Date]),-1,MONTH)) >

    so as the calculate make a row context (at least it seems to) for LASTDATE, if thought it shouldn't make a difference if you
    use FIRSTDATE, and I do get the same results in a pivot table, but the actual 'measure totals' in measure grid are quite different.
    As you'll see lastdate returns 5.5 and fist 10, but both behave the same in a p table

    Can someone help to explain what's actually happening.

    Richard.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Moving average using last and firstdate

    I have no idea what is going on here, no idea what you expect to see, nor where you expect to see it!!

    Help us to help you.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    594

    Re: Moving average using last and firstdate

    A moving monthly average , it works fine,
    I just wondered if someone could explain if there is a reason for choosing last or fist date, and why the figure in the measures grid
    are different, but the results the same.

    Richard.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 10-20-2014, 03:20 PM
  2. [SOLVED] Moving Average
    By mtndewgradon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-21-2013, 12:54 PM
  3. [SOLVED] Moving average/average function/adjustable length
    By Lv27 in forum Excel General
    Replies: 3
    Last Post: 08-16-2012, 09:43 AM
  4. Charts 5 day moving average, 10 day moving average
    By monalisa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2008, 09:50 PM
  5. Moving average of a moving average in the same cell
    By philroberts1983 in forum Excel General
    Replies: 8
    Last Post: 09-16-2008, 07:36 AM
  6. Moving Average
    By Screamer in forum Excel General
    Replies: 2
    Last Post: 12-03-2006, 02:09 PM
  7. moving average
    By tinybears in forum Excel General
    Replies: 2
    Last Post: 05-09-2006, 05:40 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1