Universal Quantiles Calculation for PowerPivot using DAX
In my last post I showed a new approach on how to calculate the median in PowerPivot using DAX. In the comments the question was raised whether it is possible to make that calculation universal for all kind of Quantiles like Median, Quartiles, Percentiles, etc. and that's what this post is about.
Lets analyze the final Median calculation from the last post: