Median calculation in PowerPivot / DAX
Although PowerPivot - in its currently implementation - lacks a dedicated 'median' function, it is possible to recreate it using existing functionality. There is a great blog entry here by Marco Russo where he describes how to calculate median over the values of a PowerPivot column.
His calculation is as follows:
Read more...Tags: dax