Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Group by 2 columns and Percentile function

Hello I have the following table:

 

TABLE:  So this is the table. We have a lot of Holders (6th column) and we have different "Monthly access ratios" so I need to find out 95% percentile of this people where they have the same "Region", and "month". So basically, I want to group by Month and Region, and percentile of monthly access ratio of all this people on this group.  I need a calculated column to calculate this please. 

 

 

 

 

My desired output is this:   But as a calculated column. So everytime the REGION is CE and APRIL 2019 = it should give me 95.45%

Grouped by Region and each month and "PERCENTILE 0.95" of monthly ratio of all consultants in that region.

 

 

 

Can you please help me on this subject?


Thank you!

 

 

1 Reply

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

    Could you pls share your pbix file ,Remember to remove confident data.

     

    Best Regards

    Lucien