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 ?
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?