Formula for calculating 95th Percentile from TAT column

[hemanth-s1]

Scenario: We have a TAT (turnaround time) column in the data and the team wants to consider the 95th percentile of that TAT column. whatever the value is eg., if the vaue is 20, then we need to ignore all those values >=20. 

Another challenging part here is every month new month data will be appended but the 95th percentile might change right ? Need a formula to calculate TAT ignoring any value more than 95th percentile value

[amitchandak]

@hemanth-s1 , refer if this can help

Power BI Window: Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw

Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4

[hemanth-s1]

No Amit, not working...
Adding to the above: I have "created on", 'closed on" and "TAT" column, i need to consider only upto 95th percentile and the rest should be ignored.

When they shared the raw data in Excel, the team used to maintain one excel and kept appending data every month. When they appending a month data they calculate 95th percentile and for rest of the rows they leave it blank.

=percentile.inc('tatcolumn',0.95) doesnt work