Forum Discussion
Finding Percentile Number in Report Builder
Hello,
I am trying to find the 1Q Percentile for a set of numbers I have coming from SQL. For example say the numbers are:
0, 2, 1, 3, 4, 5, 6, 9, 8, 7, 10
I would expect the 25th percentile to be 2.
I have to find any solution that shows how to create an expression that can calcuate this.
Hi Anonymous ,
Please try to create a PBI dataset with below dax formula:
Measure = FLOOR(PERCENTILE.INC('Table'[Column1],0.25),1)Then connect to this dataset in PBI report builder and use the measure.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
Please try to create a PBI dataset with below dax formula:
Measure = FLOOR(PERCENTILE.INC('Table'[Column1],0.25),1)Then connect to this dataset in PBI report builder and use the measure.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.