RANK measure finished
“…I always see the job through.” -Angel Eyes Yep, I said I would return and finish off the Rank measure. Time to deliver. (And this makes three straight Spaghetti Western […]
Category: Power BI
Rank continued – dealing with unknown members
TUCO: “There’s no name on it!” BLONDIE: “Well, there’s no name here, either.” Ode to YouTube HD When I used to work on Bing and would look at search logs, […]
Guest Post: Dany Hoter on Cube Formulas
“OK, I want the brooding frontman in the foreground, and the keyboard player and drum machine programmer in the back.” -Photographer for the EuroSynth band, MDX I’ve always loved this […]
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 […]
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 […]