Group by 2 columns and Percentile function

[Anonymous]

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!

[v-luwang-msft]

Hi @Anonymous ，

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

Best Regards

Lucien