+ Reply to Thread
Results 1 to 2 of 2

Sumif in powerpivot using a filter in a column with a parameter inside the same column

  1. #1
    Registered User
    Join Date
    10-30-2014
    Location
    Riga
    MS-Off Ver
    Excel 2010
    Posts
    11

    Unhappy Sumif in powerpivot using a filter in a column with a parameter inside the same column

    Hi,

    I have this powerpivot table (I am using power pivots to avoid huge vlookups, so I have no choice)

    In the table I have the number of seats booked each day for a specific departure day (we are talking about airplanes).

    On example

    Departure day - Booked day - No. of seats - incremental sales

    30Jan16 - 1jan16 - 3 - 3
    30Jan16 - 2jan16 - 1 - 4
    30Jan16 - 4jan16 - 3 - 7
    30Jan16 - 10jan16 - 5 - 12
    30Jan16 - 12jan16 - 8 - 20
    31Jan16 - 2jan16 - 1 - 1
    31Jan16 - 3jan16 - 3 - 4
    31Jan16 - 5jan16 - 6 - 10
    31Jan16 - 15jan16 - 9 - 19

    Question is, how to calculate the incremental sale column?

    I was trying something like this:

    =CALCULATE([Pax Count],BOData[DepartureDay]=[BOData@[DepartureDay]],BOData[BookedDay]<[BOData@[BookedDay]])

    (where BOData obviously is the table with the data) but of course it does not work...

    I was just trying to use the same reasoning that I would use with "sumif" (which does not work in powerpivot), but clearly "calculate" does not work the same way.

    Thank you!

    P.s.: using sumifs in the data source table is a no go... too many rows: it crashes the computer immediately

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Sumif in powerpivot using a filter in a column with a parameter inside the same column

    with a pivot table.

    see the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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: 2
    Last Post: 08-27-2015, 07:45 PM
  2. Replies: 3
    Last Post: 06-17-2015, 02:42 PM
  3. PowerPivot SUMIF type Calculated Column ERROR
    By matt4003 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-26-2015, 04:17 AM
  4. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  5. Charts with large data inside one column and one date column
    By toplisek in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-05-2013, 06:45 PM
  6. Replies: 9
    Last Post: 01-04-2013, 09:56 AM
  7. Replies: 0
    Last Post: 11-20-2012, 05:34 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