90th Percentile Issues (Not displaying correctly)
I am having issues with capturing the 90th percentile of a given set of data. I have used all the percentile forumals below with no luck. While it returns results, they seem to be incorrect. PERCENTILE.EXC('Public-Dashboard'[Unit Turnout Time],0.9) PERCENTILE.INC('Public-Dashboard'[Unit Turnout Time],0.9) PERCENTILEX.EXC('Public-Dashboard',[Unit Turnout Time], 0.9) PERCENTILEX.INC('Public-Dashboard',[Unit Turnout Time],0.9) Below is a certain set of data where you can see the results of the forumla are returning incorrect results as I did the calculation manually on paper. As you know a normal 90th percentile formula would be calculated as the following steps. Put data in chronological order Count how many data points you have (in the example below it would be 23) Take 23 * 0.9 which returns 20.7 Your 90th percent would be the 21st number or 20th number. Based on the images below I would assume it would be 110 or 118.
