Forum Discussion

harirao's avatar
harirao
Post Prodigy
6 years ago

Percentile Calculation

Hi All, Required assistance, I have to work on Percentile Calculation Normally Percentile works smaller value to larger Value I have to create/calculate 75th Percentile by using a column where Per...
Interesting Links
Need Help
Tips and Tricks
harirao's avatar
harirao
Post Prodigy
6 years ago

Hi,

Thanks for your response, please find the below example for your reference.
I have created 90th Percentile by using column "Actual visibility Weeks", where percentile is calculating from ascending order to descending order: Please correct me if i am work.

 

 

But I wanted to calculate 90th Percentile using ONLY descending to ascending order for the same column "Actual visibility Weeks", which ever month is Filer is used for visualization. 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi harirao ,

I'm not sure if I understand your requirement... Could you please check whether the below screenshot is your expected result?

1. Create a calculated column

Neg_Actually visibility Weeks = -'Sheet1'[Actually visibility Weeks]

2. Create a measure

Percentile = ABS( PERCENTILE.INC(Sheet1[Neg_Actually visibility Weeks],0.9) )

If the above information has any wrong, please correct it. Thank you.

Best Regards

Rena

  • harirao's avatar
    harirao
    Post Prodigy
    6 years ago

    Hi Anonymous,

     

    Thanks for your response. 
    Instead of creating Negative can we create a calculated colum, Larger Value to Smaller value for "Actualy Visibility weeks",  then use percentile calculation?

    Regards

    Hari

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi harirao ,

      Please try to update the formula as below:

      Percentile = PERCENTILE.INC(Sheet1[Actually visibility Weeks],0.1)

       

      Best Regards

      Rena