Learn Excel with Max -(minus) Min in a Pivot Table: Podcast #1390
Kelly wants to display a Range in a Pivot Table. Unfortunately, Calculated Fields in a Pivot Table look at each individual row, so the MAX(B2)-MIN(B2) will always be zero. PowerPivot and the DAX Measure come to the rescue here and in Episode #1390, Bill shows us how its done!
…This blog episode is the video podcast companion to the book, “PowerPivot For The Data Analyst: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.
For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions.
Entry filed under: Excel 2010, Excel 2010 In Depth, Excel and PowerPivot, Learn Excel from MrExcel, MrExcel Podcast, MrExcel Products, New MrExcel Publication, Pivot Tables, PowerPivot, PowerPivot 2010. Tags: Bill Jelen, DAX, DAX Measure, How to Display a Range in a Pivot Table, Learn Excel, Pivot Table, PowerPivot.