Articles By Rob Collie

ArticleDate Published
Tracking Performance After an Event or Treatment2012-Feb-03
Comparing scientific and other data across trials2012-Jan-31
Data of Different Grains: A Followup2012-Jan-19
In the Browser, Aesthetics Yield a Greater Return2012-Jan-11
The Greatest Formula in the World2011-Dec-06
Why PowerPivot is Better Fed From a Database2011-Nov-23
Comparing Access to PowerPivot2011-Nov-17
Adding State Alpha Sort to the Sort By Slicer Trick2011-Oct-18
User-Friendly Report Sorting With Slicers!2011-Oct-15
DAX Autocomplete Stops Working-A Workable "Fix"2011-Sep-27
Detecting ALL() - Detecting When Not Filtered2011-Sep-20
Catching Multiple Slicer Selections in a Formula2011-Sep-08
The Incredible "Iffer-Blanker-Filter" Measure2011-Sep-06
Distinct Count in PowerPivot v2 - MUCH Faster2011-Jul-28
PowerPivot V2 CTP3!2011-Jul-12
Running Totals Without a Traditional Calendar Table2011-Jul-05
The Great Precedence Project (Filter Rules for DAX)2011-Jun-14
Two tips from "the Old Country"2011-Jun-11
Portable formulas: A PowerPivot benefit you'll never believe you lived without2011-May-06
The Friendly Neighborhood Operators && and ||2011-Apr-24
A/B Campaign Analysis with Start and End Date Slicers2011-Apr-13
Are you making daiquiris or blenders?2011-Mar-23
More Fun With IF(VALUES())2011-Mar-22
The Magic of IF(VALUES())2011-Mar-09
Date and Date/Time - Sneaky Data Types!2011-Feb-27
Campaign Analysis: Seasonally-Adjusted Measures2011-Jan-19
PowerPivot Scheduled Refresh – Twists & Turns2011-Jan-04
Another way to get and use slicer values in formulas2010-Dec-10
PowerPivot for Excel 2007?2010-Dec-10
Hardware/Capacity Planning: From the Trenches2010-Nov-30
Learning DAX Measures – the “Spicy Function” Scale2010-Nov-17
Add a "Last Refreshed Date" Readout2010-Nov-01
PowerPivot Mind Meld: To Consult is to Train2010-Oct-21
Top 5 Ways PowerPivot Helps Excel Pros2010-Oct-03
1,300 Measures – Nightmare or Utopia?2010-Sep-07
Cleaner SharePoint pages, and an offer to share2010-Sep-01
A few tips on maintainability2010-Aug-31
PowerPivot VBA Macro Mania!2010-Aug-24
Extranet Analytics Products Using PowerPivot!2010-Aug-24
Pivot Refresh vs. Update – is there a real difference?2010-Aug-16
Two common PowerPivot error messages2010-Aug-16
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
 

Varigence Vivid