Calculate Median in PivotTable

Pivot Tables are one of the greatest analytical tools in Excel for it's capability to slice and dice data. It can summarize data by sum, average and even standard deviation. But the one of the basic statistical measures is the median and unfortunately that is missing from the pivot table options. Fortunately you can include that option in and it just involves creating the pivot table and adding it into the data model to write a simple DAX measure. See how it works by watching this short video.