Quartile Analysis

[Anonymous]

Hi 

I want to calculate Quartiles for PRR and RAP Performance Across two sites and for last three months. The Quartiles That I am receiving is not correct the distribution is not matching when I did it in excel. 

This is the dax command I am using:

RR_Quartiles =

var high = PERCENTILEX.INC(

FILTER('Dax Groupby',ISBLANK(('Dax Groupby'[PRR%])) = FALSE()),

('Dax Groupby'[PRR%]),.75)

var mid = PERCENTILEX.INC(

FILTER(

'Dax Groupby',

ISBLANK(('Dax Groupby'[PRR%])) = FALSE()

),

('Dax Groupby'[PRR%]),.5)

var low = PERCENTILEX.INC(

FILTER(

'Dax Groupby',

ISBLANK(('Dax Groupby'[PRR%])) = FALSE()

),

('Dax Groupby'[PRR%]),.25)

return

IF(('Dax Groupby'[PRR%]) <= low, "Q4", IF(('Dax Groupby'[PRR%]) <= mid, "Q3", IF(('Dax Groupby'[PRR%]) < high, "Q2", "Q1")))

[Anonymous]

Hi @Anonymous ,

Please share some sample data and expected result so that we could test the formula.

Best Regards,

Jay

[Anonymous · Accepted solution]

Hi,

Actually it was resolved initially I was doing it on day level basis, when I did it on monthly it sorted out