June 23, 2021
July 16, 2010
Welcome to our forum! In Excel 2013 Power Pivot doesn't have automatic date grouping or any way to group dates automatically. Instead, you need to create a date/calendar table that has a day for every year you have data for in your file, then corresponding columns for the date's month, quarter, year and any other groupings you want. You then use these date fields in your PivotTables.