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 […]
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
Catching Multiple Slicer Selections in a Formula
A long time ago I did a post on using slicer selections in Excel formulas. That technique only worked when you select single values on slicers, though – any more than one and the dreaded “(Multiple items)” foils your well-laid plans.
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.”
Running Totals Without a Traditional Calendar Table
PowerPivot provides a host of great functions like DATESYTD, DATESMTD, DATESBETWEEN, etc. that are useful for calculating many things, including a running total. But with the exception of DATESBETWEEN,
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:
