Forum Discussion
Percentile Calculation in Power BI
Hi All,
I have the following data.
I could calculate the 90th percentile in Excel as follows
=PERCENTILE(B2:B5,0.9)
which gave me
| 0:00:55 |
as result.
I tried calculating the same in power BI
Here the column "Seconds" is calculated by extracting total seconds from the column "Time".
The above measure returns the error "Unsupported Percentile".
How can we achieve this in power BI?
Any assistance you can provide would be greatly appreciated.
You'll see that some percentiles are not supported in this function and which ones depends on the number of points you've got. You can use another function that supports all percentiles for any dataset: PERCENTILE.INC - DAX Guide
2 Replies
You'll see that some percentiles are not supported in this function and which ones depends on the number of points you've got. You can use another function that supports all percentiles for any dataset: PERCENTILE.INC - DAX Guide
Hi CC2019
You could create below measure. In this measure, Seconds column should not be string/boolean/date type or you will encounter the Not Support error. You could convert Seconds column into whole number/decimal number data type.
Measure = PERCENTILE.INC('Table'[Seconds],0.9)Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
