Forum Discussion

Frequent Visitor

5 years ago

Percentile

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

Super User

5 years ago

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)