Creating Accurate Percentile Measures in DAX

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

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. Some of the most insightful BI analysis involves the use of statistics, and PowerPivot provides an excellent environment for developing statistical measures. Perhaps percentile and its cohorts will be considered for inclusion in PowerPivot V3.

Read more Part 1...

Read more part 2...



Tags: dax, v2


2007-2015 VidasSoft Systems Inc.