Forum Discussion

saramark's avatar
saramark
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)?

 

 

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper 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)

    • saramark's avatar
      saramark
      Frequent Visitor
      5 years ago

      amitchandak ,

       

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

       

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