PowerPivot and DAX papers,posts,FAQs,webcasts,samples

A Common Question:  What Caused the Change?

Thought I’d take a break from the “Refresh on SharePoint” series and talk about an age-old problem…  and how easy it is to address with PowerPivot.  There isn’t much complexity behind it, and yet it’s still much more useful and re-useable than anything you can do with Excel alone.

Let’s say you work for the fictional AdventureWorks bicycle company.  And for the past few weeks, you’ve been running a special promotion:  “Buy a Bike, Get a Free Water Bottle.”  And so far, it’s looking pretty good, as evidenced by the highlighted region on this chart:

Read more...