dax

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/

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

Another one from the Mr. XL Forum!

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

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

“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

“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

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

Greetings from Israel!

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

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

Got this question yesterday from the DJ Monkey

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

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

Post by Rob Collie Did Someone Say Deliberately

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?

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

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

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

***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

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

“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

The Superheroes of DAX, and derived measures - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2010/02/the-superheroes-of-dax-and-derived-measures/

Quick Tip: Don’t Over-Use FILTER() - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2010/04/quick-tip-dont-over-use-filter/

Why PowerPivot is Better Fed from a Database, Pt2 - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2011/11/why-powerpivot-is-better-fed-from-a-database-pt2/

Rip van Winkle wakes up and looks around I have a confession to make:  when it comes to technology, I’m a much better writer than reader.  I don’t pay near

Organizing Your Measures With a “Dummy” Table – Guest Post From Eric Hutton - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2013/02/organizing-your-measures-with-a-dummy-table-guest-post-from-eric-hutton/