Not your average PowerPivot report
DAX
PowerPivot time intelligent functions: why use ALL() and how to work around it - PowerPivotPro
Another way to get and use slicer values in formulas - PowerPivotPro
Counting “Active” Rows in a Time Period: Guest Post from Chris Campbell - PowerPivotPro
“Normalize” Your Measures for Fun and Profit! - PowerPivotPro
CALCULATE(): More Examples and Reinforcement - PowerPivotPro
Toggling Between Different Units via Slicer? - PowerPivotPro
Repeat Customers in DAX: Three Flavors - PowerPivotPro
The Diabolical Genius of “SWITCH TRUE” - PowerPivotPro
New Twist for Dynamic Segmentation: Variable Grain Control - PowerPivotPro
ISFILTERED: A Better Way to Detect Totals - PowerPivotPro
Budget Calculations That Change by Level - PowerPivotPro
One Slicer to Control Them All… - PowerPivotPro
New Customers Per Day Generalized to “New Customers per Month,” etc. - PowerPivotPro
Calendar Tables: Not Just for Formulas. Use Them on Your Pivots Too! - PowerPivotPro
Mini-Post 1 of 2: A “Better” Version of TODAY() - PowerPivotPro
Finding the Top-Selling Date, Product, etc. - PowerPivotPro
FILTER() – When, Why,
The Magic of IF(VALUES()) - PowerPivotPro
The Great Precedence Project (Filter Rules for DAX) - PowerPivotPro
Slicers For Selecting Last "X" Periods - PowerPivotPro
The Greatest Formula in the World, Part One - PowerPivotPro
Mini Post #3: Measures Can Return Text! - PowerPivotPro
Lookups based on date ranges - PowerPivotPro
Better Way to “Catch” Multiple Slicer Selections in a Formula - PowerPivotPro
Use slicer values in a calculation with PowerPivot DAX - PowerPivotPro
Resolving Many to Many relationships leveraging DAX Cross Table Filtering
ALL() Revisited - PowerPivotPro
Writing a RANK measure (and living to tell the tale) - PowerPivotPro
Dynamic Charting In Power Pivot - PowerPivotPro