Month: April 2011

DAX – The Friendly Neighborhood Operators && and ||

David Hager’s guest post below reminded me of something I’ve been meaning to share for awhile.  Here’s a feature of PowerPivot so tiny, so sensible, that I’ve had a very hard time internalizing that Excel lacks it.  In fact, I think I’ve had to re-check Excel 3-4 times to confirm for myself that Excel doesn’t have it.

Written by on April 22, 2011

DAX – A/B Campaign Analysis with Start & End Date Slicers

“Because every good story has a beginning, a middle, and an end.”

Awhile back I posted about promotional campaign analysis factoring in seasonal trends. Now let’s look at another flavor of campaign analysis: comparing results when a campaign is active versus when it was not. Sometimes this is referred to as “A/B Testing.

Written by on April 13, 2011