Excel 2013 PowerPivot Basics 11

Group By Date: Excel PivotTable vs. PowerPivot PivotTable

DESCRIPTION

See how to:
(00:47) Group By Date: Excel PivotTable: 1) Drag Date to Rows, Right-click Group, Years and Months
(02:04) Group By Date: PowerPivot PivotTable:
(02:07) Add Revenue Table to PowerPivot Data Model
(02:46) Create Date/Calendar Table
(04:35) Add Date/Calendar to PowerPivot Data Model
(05:05) Add Calculated Column for Month Number using DAX MONTH function
(05:37) Add Calculated Column for Month Name using DAX FORMAT function
(06:24) Add Calculated Column for Year using DAX YEAR function
(06:58) Sort Month Name by Month Number Column (to get months to show up in correct order)
(07:41) Create Relationship between fRevenue Table and DCalendar Table.
(08:55) Format Calculated Column so that Number Formatting shows up in PivotTable
(09:31) Hide From Client Tool (Hide unwanted Fields in PivotTable Field List)

WORKBOOKS