User-Friendly Report Sorting With Slicers!
Let’s say you are a monster Excel pro. You’re a pivot master. Nothing is beyond you – even the more complex features of Excel seem easy.
Tag: Educational Content
DAX Autocomplete Stops Working–A Workable “Fix”
By Now, You’ve Probably Seen This
So you’re typing along, writing a DAX measure. And suddenly, poof! Autocomplete stops working.
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 […]
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
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 […]
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.
Guest Post: Catalog Your Measures with a Nifty Macro
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 […]
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 […]
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 […]
Date and Date/Time – Sneaky Data Types!
These Two Columns Both Contain Dates, Right? Sure They Do! Relationships that should work, but aren’t? Here’s a quick tip, one that I think we’ll all need sooner or later. […]
PowerPivot Accelerators: The Story (And Announcing: the Private Beta)
We’ve received a lot of exciting interest and have identified about 15 great