none
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 :

    MINX(FILTER(VALUES(MyDataSerie1[Col1]),
              CALCULATE(COUNTROWS(MyDataSerie1),
                   MyDataSerie1[Col1] <= EARLIER(MyDataSerie1[Col1]) )
              > COUNTROWS(MyDataSerie1)*0.9),
       MyDataSerie1[Col1])

    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 ?

    Regards,

    Jonathan

    Monday, August 23, 2010 4:03 PM

All replies