PowerPivot DAX support for Quantile (Percentile and Quartile)

    General discussion

  • Hello,

    I recently needed to use create a DAX Measure that would return the Percentile of my serie but hit a wall as the percentile function was nowhere to be seen.

    Thanks to Frankie Yuen post and Marco Russo's post about the MEDIAN, i found a way to compute the percentile as such :

                   MyDataSerie1[Col1] <= EARLIER(MyDataSerie1[Col1]) )
              > COUNTROWS(MyDataSerie1)*0.9),

    It's working quite well so far but it is just so frustrating to use such a complex template for something that seems so common.

    Have I missed a function that would allow me to compute quantiles easily ? Do you have other suggestions ?



    Monday, August 23, 2010 4:03 PM

All replies