Detecting ALL() – Detecting When Not Filtered
“I like to carry it, you never know when you’re gonna need it.” -The much-missed John Candy as Uncle Buck A technique that you may need someday File this under […]
Category: Power BI
Profit & Loss–The Art of the Cascading Subtotal
I occasionally look through the logs of what people were Googling (or Binging etc.) when they found their way to the blog.
CIMA Part 2 – The Hidden Costs of Traditional BI
I’ve always loved the concept: we know the universe is essentially a lot “heavier” than all the things we can see
The Incredible “Iffer-Blanker-Filter” Measure
I’ve had this on my list to share for a long time, but David Churchward’s recent guest post bubbled it to the top
Guest Post – Greater Than/Less Than/Between Slicers
I get a reasonable number of questions in email each week, and rarely have time to respond to all of them. Last week though I received a question that I […]
Less Columns, More Rows = More Speed!
“Stay close! Come together! Staggered columns! Staggered columns! I mean… less columns! More rows!” -General Maximus Speedicus Queryus A Long-Held Belief, Quantified For a long time now I have been […]
Guest Post: TOPN in PowerPivot V2
Well folks I haven’t had much time to play with the V2 Beta (aka CTP3) yet. A lot going on over the past week:
PowerPivot V2 CTP3!
CTP3 Adaptive = “Public Beta” What the heck is a CTP, you ask? Well it’s a “Community Technology Preview.”
DAX – Precedence Part 3: ALLEXCEPT vs. ALL w/ VALUES
This will be a quick one. I think.
In part two, we left off with the observation that VALUES() can “trump” ALL() even when VALUES() is applied to a column that is not on the pivot:
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:
DAX – The Great Precedence Project (Filter Rules for DAX)
“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!
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.