DAX ALL() Revisited
“He has no filter. He says whatever comes through his mind. He never edits himself.” Revisiting ALL() Yes, I’ve used ALL() a number of times already. But I’ve never covered […]
Month: February 2010
Generating a Tag Cloud via PowerPivot
“Navajos say it is good plan to have two arrows for one bow” – Chief Thundercloud Thanks to Rob Collie for letting me do another guest post. There will be […]
The Superheroes of DAX, and derived measures
“Did someone say DAX?” I wanted to start today’s post with a quick thank-you to the guys who tirelessly answer my DAX questions. Marius Dumitru, Howie Dickerman, and Karen Aleksanyan. […]
DAX SUMX() – Power BI’s 5-point palm, exploding fxn technique
“AGAIN!” -Pai Mei SUMX() – the great iterator Have you ever written an array formula in Excel? (Don’t worry, most people haven’t). Have you ever written a FOR loop in […]
DAX: I’ve been shortchanging you
Mmmm! Daaaamn, Jimmie! This is some serious gourmet DAX! Usually, me and Vince would be happy with some freeze-dried Taster’s Choice right, but he springs this serious GOURMET DAX on […]
Sweden: the full videos
In case you missed them, the full videos of my presentation in Sweden were posted last week. They are long – I was on stage for over two hours combined, […]
Quick Data Prep Trick: Use a Flat Pivot!
Today I had a huge source table that looked like this: Store Month Payment Type Some Number A Jan Cash 10 A Jan Credit 12 A Jan Debit 13 A […]
Surprising Example of Power BI Compression
“Best not analyze too deeply on this one, huh?” A long time ago I promised a guy named Sam that I would dig up some examples of PowerPivot compression. I […]
PowerPivot Data in Scatter Charts, etc.
This was going around on the MS-internal discussion list this past weekend: At right is a list of all chart types in Excel. But not all of them are supported […]
Introducing CUBESET() and CUBERANKEDMEMBER()
“Where does he get such WONDERFUL toys???” -Kasper de Jonge (To be honest, Kasper probably looks nothing like this. I’ve never been to the Netherlands, but based on the fashions […]
Parameterizing the report
In the Parameterized Report, how do I get the “Fan Pts” column on the far right of the cube formula report to respond to those parameter cells in the top […]