Create a new calculated table with Quartile calculation

[esgaranel]

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:

https://docs.google.com/spreadsheets/d/1qvSOpoYcbkqsj2YSPqtfD_w04rf2ixY5/edit?usp=share_link&ouid=10...

[AlB]

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.