Median calculation in PowerPivot / DAX

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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

 

2007-2015 VidasSoft Systems Inc.