topic Re: Percentile in DAX Commands and Tips

Percentile

saramark — Wed, 16 Sep 2020 07:45:40 GMT

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)?

Re: Percentile

amitchandak — Wed, 16 Sep 2020 07:51:11 GMT

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)

Re: Percentile

saramark — Wed, 16 Sep 2020 08:04:21 GMT

amitchandak ,

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

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