Percentile

[saramark]

Hi, 

how can I write the same formula in Power Bi in order to obtain the same result as shown below (integers between 1 and 5)?

[amitchandak]

@saramark ,

new column =

switch( True()
([A]) < PERCENTILE.INC([A], 0.2) ,1,
([A]) < PERCENTILE.INC([A], 0.4) ,2,
([A]) < PERCENTILE.INC([A], 0.6) ,3,
([A]) < PERCENTILE.INC([A], 0.8) ,4,
5)

new measure =

switch( True()
max([A]) < PERCENTILE.INC([A], 0.2) ,1,
max([A]) < PERCENTILE.INC([A], 0.4) ,2,
max([A]) < PERCENTILE.INC([A], 0.6) ,3,
max([A]) < PERCENTILE.INC([A], 0.8) ,4,
5)

[saramark]

@amitchandak ,

it seems thee is something wrong in the syntax...

([A]) < PERCENTILE.INC([A], 0.2) ,1,