Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Hi @Anonymous ,
Could you pls share your pbix file ,Remember to remove confident data.
Best Regards
Lucien
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |