Forum Discussion
Create a new calculated table with Quartile calculation
How can you calculate quartiles in Power BI? In Excel there is a function but in Power BI it doesn't.
I attach the link of a data set to perform the example.
The result should be displayed in a new calculated table not in a visual.
LINK TO DATASET:
1 Reply
- AlB
Community Champion
Hi esgaranel
Have you tried percentile.exc or percentile.inc
You can calculate the cut-off values with those and then filter your original table to keep/drop values above/below
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
