PowerPivot DAX support for Quantile (Percentile and Quartile)

Question

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