When selecting a date field as a measure in pivot view, there is no way to choose a meaningful aggregation (e.g. mean, min, max). It seems strange given that date aggregation works fine everywhere else. Is it possible to add all aggregation functions for date measures in Pivot Views?
This option is available in earlier version of the Pivot View. You can still access it, by going to the Pivot View Tools>Other>View version and select Pivot 1. Depending on the interest, we might add this option in Pivot 2 at some point.