DAX

“THAT’s not a PivotTable!  Oh wait…” -Bill Gates (OK, so I turned it into a movie quote of sorts by using the picture of Anthony Michael Hall playing

Posted by: Kasper de Jonge Last week I got a most excellent question from Sasha at my question page. Using my timeintelligent function screencast Sasha created a workbook using

***UPDATE:  An even better technique is now posted here. The new technique is much less hassle. Back in June, Kasper posted a trick which lets you detect a

“There's a Fight Club up in Delaware City.”     “Yeah, I heard.” “There's one in Penns Grove too.”     “Bob even found one up

Guess Post by Scott Senkeresty Intro Rob is taking a much-needed vacation this week, so you get to hang out with me again.

Is this possible? Someone at Microsoft asked me this question the other day:

Post by Rob Collie In 2004, There Were 2,561 Customers Who Bought Something in the Southwest.But How Many of Those Were Repeat Customers?

Post by Rob Collie Did Someone Say Deliberately

By Avichal Singh [Twitter] Dynamic segmentation or banding has been covered in PowerPivotPro articles in the past and in beautiful detail by the Italians

Measure Matches at the Shape Level (Orange Cells) But Matches Down at the Color Level Quick Post Today I’m halfway on vacation today in Florida, vis

Got this question yesterday from the DJ Monkey

The Pivot On the Left is Correct and the Pivot on the Right is Not.But the Formulas Are the Same in BOTH Pivots! A Semi-Common Question From time to

Two mini-posts today:  this one and then an updated ROI Quadrant. This one falls under the “quick tip” category (and the “MacGyver” category we

Greetings from Israel!

A recent comment/question alerted me to the fact that I’ve never devoted a post just to this very useful (and often misunderstood) function.  Ti

“I'm Dan Marino, and IF() anyone knows the VALUE() of protection, it's me.” Boom!  An Ace Ventura quote finally graces the blog.  Yes folk

“Wait a minute. There might be legal precedent. Of course. Land snatching. Let's see, land, la-land...see snatch. snatch...snatch...ah! Haley vs. United st

Guest post by David Churchward Using Time Intelligence in PowerPivot can appear scary when you first start using it and I

Yes, That IS a Measure Third and Final Mini-Post for Today Got a question from a friend yesterday that made me realize I should share this:  in

Another one from the Mr. XL Forum!

It’s Actually VERY Simple to Catch Users’ Slicer Selections in Excel Formulas,IF You Are Using PowerPivot (AKA the 2013 Data Model Feature) A Popula

Use slicer values in a calculation with PowerPivot DAX - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2010/06/use-slicer-values-in-a-calculation-with-powerpivot-dax/

Resolving Many to Many relationships leveraging DAX Cross Table Filtering via Instapaper https://gbrueckl.wordpress.com/2012/05/08/resolving-many-to-many-relationships-leveraging-dax-cross-table-filtering/

ALL() Revisited - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2010/02/all-revisited/

Writing a RANK measure (and living to tell the tale) - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2010/03/writing-a-rank-measure-and-living-to-tell-the-tale/

Dynamic Charting In Power Pivot - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2014/08/dynamic-charting-in-power-pivot/