+ Reply to Thread
Results 1 to 2 of 2

DAX formula help!! (Calculating rolling 3 months)

  1. #1
    Registered User
    Join Date
    12-11-2015
    Location
    Texas
    MS-Off Ver
    MS Office 2013
    Posts
    18

    Exclamation DAX formula help!! (Calculating rolling 3 months)

    I am trying to calculate the rolling three months sum for a particular table. For Example I have a Pivot table I built similar to this:

    1/31/2015 10
    2/28/2015 5
    3/31/2015 4
    4/30/2015 3
    5/31/2015 2
    6/30/2015 5
    7/31/2015 6
    8/31/2015 7
    9/30/2015 2
    10/31/2015 3
    11/30/2015 5
    12/31/2015 4

    Each date has a corresponding number i.e. Sum(Values)... For each of the date, I don't want the sum for THAT month, but instead want the sum of that month PLUS the two prior month and have it show up in that current month.

    For example in row 12/31/2015 you will see 12 (4+5+3)
    in 11/30/2015 you will see 10 (5+3+2)
    in 10/31/2015 you will see 12 (3+2+7)
    etc, etc, etc...

    How do I write this DAX formula so I am pulling in the rolling three month value for that month??

    Thanks!

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: DAX formula help!! (Calculating rolling 3 months)

    Are you looking to add a new column with the rolling three month total, or are you looking to replace your existing column? If it's the latter, where are those (current) values coming from?

+ 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. [SOLVED] Formula for calculating 12 month rolling period
    By Stroodle in forum Excel General
    Replies: 1
    Last Post: 06-08-2016, 09:42 AM
  2. [SOLVED] Need a formula to sum a rolling three months based on input date
    By dc0822 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-10-2015, 06:11 PM
  3. [SOLVED] Fix Formula to total a row by month for a rolling 12 months
    By heresteve2 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-04-2014, 03:52 PM
  4. [SOLVED] Rolling Calendar forumula to be used with another formula for acquiring numbers for months
    By RickMadsen in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-12-2014, 08:52 AM
  5. Rolling 12 month formula for calculating absence
    By keileyoneill in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-03-2014, 09:52 PM
  6. Formula for rolling back three months
    By stryped in forum Excel General
    Replies: 29
    Last Post: 12-21-2011, 12:39 PM
  7. Sum of Rolling 12 months formula
    By b_motl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2008, 09:07 PM

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