Power BI Quartile Analysis

[cyborgandy]

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.

Advisor Number	Advisor Name	Count of NPS Advisor	Sum of NPS %
XXXX	XXXXXXXXXXXX	18	22%
XXXX	XXXXXXXXXXXX	23	48%
XXXX	XXXXXXXXXXXX	32	9%
XXXX	XXXXXXXXXXXX	21	14%
XXXX	XXXXXXXXXXXX	18	6%
XXXX	XXXXXXXXXXXX	37	43%
XXXX	XXXXXXXXXXXX	18	56%
XXXX	XXXXXXXXXXXX	21	24%
XXXX	XXXXXXXXXXXX	32	31%
XXXX	XXXXXXXXXXXX	19	42%
XXXX	XXXXXXXXXXXX	21	33%

[v-chenwuz-msft]

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]

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

[v-chenwuz-msft · Accepted solution]

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.