The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I am trying to find the Percentile (75%) of the below table for the colmun "Order Lines/Order".
All the columns (except the month) are measures.
I am familiar with the proper functions for the PRECENTILE but these require tables and not measures.
Could you please advise?
Solved! Go to Solution.
Hi,
You can use PERCENTILEX functions to get this:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi,
You can use PERCENTILEX functions to get this:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
10 | |
7 |