DAX – Precedence Project Part Two: VALUES()
OK, picking up from part one…
Let’s start with a simplified version of last post’s pivot – remove one of the row fields, and all of the measures but the base Total Sales measure:
OK, picking up from part one…
Let’s start with a simplified version of last post’s pivot – remove one of the row fields, and all of the measures but the base Total Sales measure:
“Wait a minute. There might be legal precedent. Of course. Land snatching. Let’s see, land, la-land…see snatch. snatch…snatch…ah! Haley vs. United states. Haley 7, United States nothing. You see, it can be done!
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.
“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.
David Hager is At It Again
A short two weeks after his truly creative Measure Catalog Macro post, David Hager is back with a heavyweight DAX post.
A Lasting Metaphor Many years ago, I was designing a feature for Excel 2003. And the VP of our division of Office, a man named Richard McAniff, didn’t like the […]
UPDATE: Uploaded a new version of the macro file that David provided that fixed a couple of small problems. Also, I fixed a typo (I had it as XSLM, not […]
“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 […]
“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 […]
We’ve received a lot of exciting interest and have identified about 15 great
“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 […]
So How Many Servers Do I Need in My PowerPivot SharePoint Farm?
As people increasingly move up from just dabbling with the addin, and decide to start leveraging the publish/schedule/share/secure benefits of the PowerPivot for SharePoint infrastructure, I am getting this question more frequently.