Forum Discussion

cyborgandy's avatar
cyborgandy
Helper II
4 years ago
Solved

Power BI Quartile Analysis

Hi All,   I have below data set with more than 500 rows I want to add  quartile wise disturbutation as per NPS score like A, B,C,D which we do in excel, is it possible to do it on power bi.   ...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi cyborgandy ,

     

    Please try this code:

    0.25 Bottom Quartile = PERCENTILE.INC('Table'[Sum of NPS %],0.25)

     

    If you need more help, please share your pbix without sensitive data and expect result.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi cyborgandy ,

 

Not quite sure what you mean by A,B,C,D in your excel. Can you give some example data and explain how to calculate quartile?

 

Or you can use PERCENTILE.INC(<column>, 0.25) to do that in power bi.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

cyborgandy's avatar
cyborgandy
Helper II
4 years ago

Yes I am looking for the same outcome like .75 Top Quartile, 0.50 Medium Quartile,0.25 Bottom Quartile

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi cyborgandy ,

     

    Please try this code:

    0.25 Bottom Quartile = PERCENTILE.INC('Table'[Sum of NPS %],0.25)

     

    If you need more help, please share your pbix without sensitive data and expect result.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.