Articles By Rob Collie

ArticleDate Published
Slicers and pivot update performance2010-Jul-05
PowerPivot field list and Excel field list at same time!2010-Jun-27
Automating the “Site Visitors” XL Report2010-May-07
Quick Tip: Don’t Over-Use FILTER()2010-Apr-08
Writing a RANK measure (and living to tell the tale)2010-Mar-10
Revisiting ALL()2010-Feb-25
SUMX() – The 5-point palm, exploding fxn technique2010-Feb-24
Rob Collie PowerPivot video (from Swedish UG meeting)2010-Feb-11
Surprising Example of PowerPivot Compression2010-Feb-09
PowerPivot Data in Scatter Charts, etc.2010-Feb-06
Pivots, I have not forgotten ye!2010-Feb-05
Introducing CUBESET() and CUBERANKEDMEMBER()2010-Feb-03
Parameterizing the report2010-Feb-01
PowerPivot for SharePoint Video2010-Jan-29
Rob Collie (PowerPivotPro) videos on YouTube2010-Jan-27
Not your average PowerPivot report2010-Jan-19
The MIE Podcasts – Rob Collie2010-Jan-13
Touchdown Problem Solved, and COUNTROWS2010-Jan-09
DAX CALCULATE, and Rapid Iteration2009-Dec-17
PowerPivot DAX: CALCULATE is a supercharged SUMIF2009-Dec-15
DAX's CALCULATE() function - Pivots will never be the same2009-Dec-09
Putting the "Intelligence" in "Business Intelligence"2009-Dec-07
Visualizing SQL Indices with PowerPivot2009-Dec-05
Introducing PowerPivot DAX Measures2009-Nov-16
Temperature Mashup Example2009-Nov-13
DAX: The =RELATED() Function2009-Nov-10
A 48 hour case study from Bing - Zero to Sixty :)2009-Nov-10
PowerPivot's impact on BI pros?2009-Nov-09
What is PowerPivot?2009-Oct-28
Announcing the Great Football Project (PowerPivot)2009-Oct-27