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 percent...
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.
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.
This worked perfectly, thank you very much!