Finding Percentile Number in Report Builder

[PeteSil1020]

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.

[Anonymous · Accepted solution]

Hi @PeteSil1020 ,

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.

[PeteSil1020]

This worked perfectly, thank you very much!