In the dialog box, select a column that contains unique values, with no blank values. In the Design tab, click Mark as Date Table. In the Power Pivot window, select a table that contains dates.
With the Mark as Date Table dialog box, you specify a unique date column, which enables the use of advanced date filters against Power Pivot data in Excel pivot reports.Īdvanced 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 Power Pivot field list. 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 Power Pivot window. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 More.
0 kommentar(er)
