[ 4:57 ] Skip background and explanation!
Using Excel power pivot and DAX function to get a median value in Excel Pivot table. DAX functions allow us to create custom "measures" which are basically just custom formulas that we can drop into out pivot tables. No Array functions required! The best thing about this method is that it will work great with large data sets and multiple grouping criteria (rows and columns). This is much more flexible than array functions but it does require Excel Power Pivot add in to use the DAX formulas.
Array Method: • Median Value in Excel Pivot Table
Check out my channel for more videos and tutorials for engineers!
Like, follow, share and don't be afraid to drop me a comment/message with feedback, questions, or video suggestions!
Thanks for watching!
Channel Link: / @theengineeringtoolboxchannel
Other great content!
Best Free Engineering Software:
• EVERY Engineer Should Know About This...
Removing Outliers from Excel Pivot Table (Pt 2):
• Removing Outliers From Excel Pivot Ta...
Removing Outlier from Excel Pivot Table (Pt 1):
• Excel Removing Outliers from Pivot Ta...
Follow and interact!
Twitter: / theengtoolbox
Facebook: / theengineeringtoolbox
#ExcelForEngineers
#Excel
#ExcelPivotTables
#EngineeringToolbox
#EngineeringTutorials
#Engineering