+ Reply to Thread
Results 1 to 2 of 2

Advantages of powerpivot over pivottable from DAX book

  1. #1
    Forum Contributor
    Join Date
    09-30-2015
    Location
    LA my baby
    MS-Off Ver
    2013
    Posts
    727

    Advantages of powerpivot over pivottable from DAX book

    I'm reading this book and the author says" Stop and think about that 'rearrange the pivot and the formulas still work' point for a moment". Let's say your workgroup originally requested a report that displayed Sales per Day and Sales per Transaction grouped by Month. How would you build that report in normal Excel? You couldn't just write formulas in a pivot. You've have to do some pretty serioues formula alchemy to get it working"

    Wouldn't it actually be easy to do that in a pivot table? I don't see the different between creating the formulas in a pivot table vs. creating them in powerpivot. You would just create a calculated field in pivot table for Sales per Day and Sales per Transaction in the pivotable. The transaction doesn't exist, but you could just create it in the pivot table with a count. What am I missing?

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,339

    Re: Advantages of powerpivot over pivottable from DAX book

    A little context would be nice but calculated fields in regular pivot tables always sum the source fields. You can't do a sum of one divided by a count of another for example. DAX is much more flexible.
    Everyone who confuses correlation and causation ends up dead.

+ 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. 1,000,000 rows, powerpivot vs. pivottable
    By stephme55 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-29-2016, 02:03 PM
  2. Replies: 4
    Last Post: 07-23-2015, 03:35 PM
  3. Replies: 2
    Last Post: 09-11-2014, 12:08 PM
  4. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  5. Shift rows below PivotTable down when PivotTable expands (PowerPivot)
    By hektisk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2012, 10:19 PM
  6. Replies: 0
    Last Post: 11-20-2012, 05:34 AM
  7. XML Advantages in Excell
    By Piotr in forum Excel General
    Replies: 3
    Last Post: 04-13-2006, 08:10 AM

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