DAX – Subtotals and Grand Totals That Add Up “Correctly”
Busy week here at the MVP Summit in Redmond. As usual, I can’t tell you anything I have learned this week – it’s strictly under NDA.
Category: Quick Tips & Tricks
Lookups based on date ranges
Another one from the Mr. XL Forum!
…and the word “forum” gives me an excuse for a blast from the past…
Data of Different Grains Using DAX: A Followup
Quick Recap: We Created a Separate “Periods” Table In last week’s post, I explained how PowerPivot can very easily help you solve the “Budget vs. Actuals” problem or any other problem where you have data sets
Sales/Budget: Integrating Data of Different “Grains”
Some of you know that I’ve been writing a series of articles for the Chartered Institute of Management Accounts, aka CIMA
DAX – Switching Subtotals On & Off Dynamically Using DAX in PowerPivot
In this post, I’ll explain how to create a dynamic measure that works out whether a subtotal is needed and displays that subtotal accordingly. I’ll be using the report that was created as part of the Cash Flow Statement post.
Adding State Alpha Sort to the Sort By Slicer Trick
Sorting by State! How did I miss that? In a comment on Thursday’s post, Janet asked an excellent question: what about sorting by state name?
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.
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 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.