Category: DAX

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

DAX – More Fun With IF(VALUES())

“I mean, IF() I’m paying top dollar, I want a little production VALUE()” I bet you thought I was out of movie quotes for IF(VALUES()) didn’t you!  If I had […]

Written by on March 12, 2011

DAX – The Magic of IF(VALUES())

“I’m Dan Marino, and IF() anyone knows the VALUE() of protection, it’s me.” Boom!  An Ace Ventura quote finally graces the blog.  Yes folks, that fine work of American cinema […]

Written by on March 9, 2011

Campaign Analysis: Seasonally-Adjusted Measures

 “We sure sold a lot of toilet paper around Halloween this year.  That promotion we were running must’ve been REALLY effective!” -Retail Manager Extraordinaire    Halloween Mischief Has Nothing to […]

Written by on January 16, 2011