Category: Uncategorized

Beta-Testing the “ROI Quadrant”

If you’ve been around Business Intelligence for the past ten years, you’ve seen a LOT of Gartner’s Magic Quadrant.  You can see the 2012 version here on Microstrategy’s web site.

Written by on May 3, 2012

Creating Accurate Percentile Measures in DAX – Part I

Equivalents of Excel’s Percentile, Quartile, and Median functions are perhaps the most significant omissions in Denali’s DAX statistical function library. Quartile and Median are actually special cases of percentile, and in this post, we calculate these special cases.

Written by on September 29, 2011

Catching Multiple Slicer Selections in a Formula

A long time ago I did a post on using slicer selections in Excel formulas.  That technique only worked when you select single values on slicers, though – any more than one and the dreaded “(Multiple items)” foils your well-laid plans.

Written by on September 8, 2011