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]) )
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 ?
Does the above quartile calculation accommodate both odd and even number data sets?
Brent Greenwood, MS, MCITP, CBIP // Please mark correct answers and helpful posts // http://brentgreenwood.blogspot.com
I tried Gerhard Brueckl's version, but it did not work for me. The above formula is the only one that seems to somewhat work so far.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?