ISFILTERED: A Better Way to Detect Totals - PowerPivotPro
DAX
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
SQLBI - Marco Russo : How CALCULATE works in DAX
Football data source tables - PowerPivotPro
Parameter Table – DAX Patterns
Using Parameters in Power Query Extracts | Devin Knight
Handling Different Granularities – DAX Patterns
Use slicers to select the facts in a pivot chart | Erik Svensen
DAX Query Syntax Reference
Year to Date in Previous/Prior Year - PowerPivotPro
Simplifying Time Calculations and the User Experience using Disconnected Slicers - PowerPivotPro
Implementing a ‘Time Calculations’ Dimension in Tabular via DAX | Salvo(z)