+ Reply to Thread
Results 1 to 1 of 1

Month-Over-Month Change When Missing Value for Month

  1. #1
    Registered User
    Join Date
    11-01-2021
    Location
    New Orleans, Louisiana
    MS-Off Ver
    2016
    Posts
    2

    Month-Over-Month Change When Missing Value for Month

    I have a pivot table that calculates the price per pound (PPP) of resin by month.

    PPP = DIVIDE ( Sum(PO Dollar Amount),Sum(PO Quantity))

    I am looking to calculate the percent change from month to month.

    LastMonthPPP = CALCULATE([PPP],DATEADD('Calendar[Date]',-1,MONTH)
    Month Over Month % Change = (PPP - LastMonthPP) / LastMonthPPP


    However, some months we do not buy any product.

    Price Per Pound Missing Months.png

    The result is "NUM" errors and false "-100%" results because of the lack of a values for every month.

    Price Per Pound Errors.png

    I believe I need to use a variable to store and recall the last valid PPP but cannot fully grasp this concept yet.
    Attached Files Attached Files
    Last edited by JGroeger; 05-23-2022 at 02:02 PM.

+ 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: 4
    Last Post: 09-04-2020, 04:02 PM
  2. [SOLVED] Return Month-on-Month growth using current month-prior month/prior month per country
    By losincog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2020, 05:37 AM
  3. Replies: 16
    Last Post: 11-23-2019, 01:41 PM
  4. [SOLVED] Change VBA code to report last month i.e. May as opposed to this month i.e. June in file n
    By robertguy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-02-2018, 11:09 AM
  5. [SOLVED] Calculation of days per month for dates beginning in one month and ending in another month
    By Fahrettin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2015, 04:52 PM
  6. [SOLVED] Determine work days in current month or next month based on day of the month
    By sbrnard in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-29-2014, 05:14 PM
  7. [SOLVED] Auto instert Month names for This month, Last month and Next month
    By hemal89 in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2013, 12:01 PM

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