Use slicer values in a calculation with PowerPivot DAX - PowerPivotPro
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/
The Great Precedence Project (Filter Rules for DAX) - PowerPivotPro
“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
New Twist for Dynamic Segmentation: Variable Grain Control - PowerPivotPro
By Avichal Singh [Twitter] Dynamic segmentation or banding has been covered in PowerPivotPro articles in the past and in beautiful detail by the Italians
Another way to get and use slicer values in formulas - PowerPivotPro
***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
PowerPivot time intelligent functions: why use ALL() and how to work around it - PowerPivotPro
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
The Superheroes of DAX, and derived measures - PowerPivotPro
The Superheroes of DAX, and derived measures - PowerPivotPro via Instapaper http://www.powerpivotpro.com/2010/02/the-superheroes-of-dax-and-derived-measures/
Why PowerPivot is Better Fed from a Database, Pt2 - PowerPivotPro
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/
A mystifying and awesome solution for many 2 many - PowerPivotPro
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
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/