Export (0) Print
Expand All

Mark as Date Table Dialog Box

SQL Server 2012

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

The Mark as Date Table dialog box appears when you click Mark as Date Table button or choose Date Table Settings in the Design tab of the PowerPivot window. With the Mark as Date Table dialog box, you specify a unique date column, which enables the use of advanced date filters against PowerPivot data in Excel pivot reports.

Advanced date filters appear for row and column labels in a PivotTable or PivotChart when you add a field from the date table to the Row Labels or Column Labels of the PowerPivot field list.

To change the date properties

  1. In the PowerPivot window, select a table that contains dates.

    In the Design tab, click Mark as Date Table.

  2. In the dialog box, select a column that contains unique values, with no blank values.

  3. Click OK.

To use advanced date filters

  1. Navigate to a PivotTable or PivotChart in the same workbook.

  2. Add a column from the Date table to the Column Labels or Row Labels area of the PowerPivot field list.

  3. Click the down arrow next to Column Labels or Row Labels in the PivotTable.

  4. Point to Date Filters, and then select a filter from the list.

Date filter list
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft