Hi, This is not the first time I am working with Percentile calculations in PBI. However within a report Percentile calculations seem to be working odd. The numbers are incorrect and also the for...
Yes, That is what I mean. Percentile Calculation does not return the correct value in Power BI Desktop.
Formula used:
Percentile95DECancellation = PERCENTILE.EXC('DE_FDHE_Cancellation_Time'[timeToCancelDE],0.95)
Percentile98DECancellation = PERCENTILE.EXC('DE_FDHE_Cancellation_Time'[timeToCancelDE], 0.98)
Percentile99DECancellation = PERCENTILE.EXC('DE_FDHE_Cancellation_Time'[timeToCancelDE], 0.99)
I have the sample data, Dont know how to attach it here. :( Some values are as below for example
| 31.01:09:47.0103292 |
| 16.05:24:17.5955781 |
| 13.02:39:28.4676111 |
| 7.14:21:18.0016487 |
| 6.02:09:30.6411037 |
| 5.22:42:12.2269722 |
| 5.21:35:13.7168207 |
| 5.17:50:06.5552803 |
| 5.14:25:02.5225867 |
| 5.00:24:06.9244826 |
| 4.11:55:13.5877447 |
| 4.03:50:18.6386796 |
| 3.23:06:15.8808008 |
| 3.22:08:25.4451047 |
| 3.17:55:23.4778271 |
| 3.06:34:19.6658091 |
| 3.03:12:20.9459942 |
| 3.00:55:37.6928401 |
| 2.23:24:03.3628356 |
| 2.23:21:16.0764442 |
| 2.12:59:38.0208098 |