Hello all. I'm using Excel 2013 to create a new dashboard. Currently I can't group date in powerpivot tables the option is disabled while I can do this for sure with the regular pivot tables for the same data set. In another file I created earlier (using Excel 2010 and PowerPivot 2, later upgraded to Excel 2013 format) I can group date in powerpivot tables. There are no blank cells in the date field and of course some repeated dates are available in the 2 files (the working and the new one). Your help would be deeply appreciated.