Introducing PowerPivot DAX Measures
Up until this point, I’ve just used DAX (PowerPivot’s extension to the Excel formula language) to create calculated columns in the PowerPivot window. There’s a lot of utility in DAX […]
Month: November 2009
A 48 hour case study from Bing – Zero to Sixty :)
“When you can snatch this pebble from my hand, you will be re- HEY, GIVE THAT BACK!” -Me I promised a guest post, and a guest post I deliver 🙂 […]
Relationships, Pivots, and DAX: The Payoff of Power BI Data Modeling, Part Two
(Continuing the series on the Great Football Project…) OK, remember in the previous step, we saw how a relationship between Plays and CleanPlayers suddenly let me use a single PivotTable […]
Relationships, Pivots, and DAX: The Payoff of Power BI Data Modeling, Part One
Recall that in yesterday’s post I linked my FactEvent table to the CleanPlayers table via a relationship. Time for the payoff. But you know what? I’m tired of calling it […]