Month: September 2011

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