+ Reply to Thread
Results 1 to 1 of 1

Power Pivot Row = Month , Year = Column comparison

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

    Power Pivot Row = Month , Year = Column comparison

    Hi, this relates to power pivot; I have a year on year growth measure staring with sply;

    Please Login or Register  to view this content.
    and this works if I have Year and month in rows but if I put year in columns so icols = 2011 , 2012
    and rows = Months , "total Sales" measure will give a correct result for each year but if I put a sply or growth measure in it fails,
    I have tried to show the result I would like by using two total measure to illustrate what I am looking for,

    I have attached a work book withe the examples , I cant' see why it does not work? The error message say DATEADD only works with contiguous date selection,
    but I get the same message when I try and use the second "totals" measure which does not use dateadd?


    Richard.
    Attached Files Attached Files

+ 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. Power Bi Year Month column
    By Dicken in forum Office 365
    Replies: 0
    Last Post: 12-23-2022, 12:11 PM
  2. [SOLVED] Comparison formula Year and Month
    By Shan54321 in forum Excel General
    Replies: 5
    Last Post: 01-28-2020, 04:21 AM
  3. Is it possible to split year(column) into month(column) in pivot table ?
    By dibyendu2280 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-19-2019, 07:24 PM
  4. Pivot / Power Pivot - Year To Date Column
    By Ballet4ever in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 04-30-2019, 08:42 AM
  5. SALES COMPARISON BY WEEK NUMBER, MONTH, QUARTER AND yEAR
    By faodavid in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-30-2017, 02:53 PM
  6. [SOLVED] cumulative comparison with last year of month to date
    By johnbtor in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 09-04-2012, 10:38 AM
  7. [SOLVED] Showing data per month & year for comparison
    By gman in forum Excel General
    Replies: 3
    Last Post: 09-06-2005, 09:05 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