I have an Excel 2010 pivot table based on 3 Power Pivot tables, which summarises goods moving on certain dates from one region/country into another region/country. An example would be 500 units in Jan 2015 moving from Europe/UK to Asia/Singapore. The pivot table sums the quantities by months (columns) and years (rows).
What I would then like to do is return the average, min and max for all months across the years (2007-2016). I can do that easily enough by adding a standard Excel formula to the right of the pivot table, =AVERAGE(B23:K23), but I was hoping there might be a DAX expression that I could use to calculate the values instead. Does anybody have any suggestions as to how I could do this ?
Thanks for any help
Bodders
What I would then like to do is return the average, min and max for all months across the years (2007-2016). I can do that easily enough by adding a standard Excel formula to the right of the pivot table, =AVERAGE(B23:K23), but I was hoping there might be a DAX expression that I could use to calculate the values instead. Does anybody have any suggestions as to how I could do this ?
Thanks for any help
Bodders
