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.
Category: Power BI
DAX – Slicers For Selecting Last “X” Periods
Using Time Intelligence in PowerPivot can appear scary when you first start using it and I’ve seen some weird and wonderful ways of attacking it, some that look like we’re calling into question the validity of the global phenomenon that is time and others that are quite simply brilliant.
PowerPivot ROI Comparison: CIMA Part Three
It’s that time of the month again folks… you know… for the next installment in my series for CIMA Insight!
Creating Accurate Percentile Measures in DAX – Part I
Equivalents of Excel’s Percentile, Quartile, and Median functions are perhaps the most significant omissions in Denali’s DAX statistical function library. Quartile and Median are actually special cases of percentile, and in this post, we calculate these special cases.
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 […]
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: