Forum Discussion
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
Community Support
Hi Anonymous ,
Could you pls share your pbix file ,Remember to remove confident data.
Best Regards
Lucien