Forum Discussion
Percentile calculation issue
I have this table below for comparison, Excel value are the expected one however Power BI result returns some incorrect values (italicized values). Formula Used is 95th Percentile = PERCENTILE...
Hi v-joesh-msft ,
I actually filtered out 0 values. so no 0 value is present in the 'Consolidated Data'[Value] column.
Hi Seira088 ,
Could you share your sample data for us to have a test if you don't have any Confidential Information?
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.