Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sarath5140
Helper I
Helper I

Calculate 90th Percentile formula calculation

Hi Folks,

 

I am bit confused with 90th percentile formula calculation in power bi and normal percentile formula calculation. Could you please advice which one should i go with.

 

Example :- This is the below column I wanted to calculate the 90th perncentile for the below range of values.

 

               Time(in minutes)
26
38
72
95

 

I am using the Dax = Percentile.Inc(Table[Time(in minutes),0.90) --> 88.1 is my 90th percentile output.

 

Normal Percentile Calculation :-

 

For n=90

F= 90*4/100=3.6, rounding up = 4

 

Then TTD 90 percentile = 95(because my 4th index value is 95) 

 

Based on these can you tell me which is the right value and If i have to implement the normal percentile calculation in powerbi how can i acheive this using measure.

 

Thanks for your help!

 

1 REPLY 1
v-cherch-msft
Employee
Employee

Hi @sarath5140 

 

Please check if the below post could help you.

https://community.powerbi.com/t5/Desktop/Dynamic-calculation-of-percentiles/td-p/458233

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.