Excel 2013 PowerPivot Basics #11: Group By Date: Excel PivotTable vs. PowerPivot PivotTable
58.1 هزار بار بازدید -
10 سال پیش
-
Download file:
Download file: http://people.highline.edu/mgirvin/ex... Scroll to down to PowerPivot Section.
See how to:
1. (00:47 minute mark) Group By Date: Excel PivotTable: 1) Drag Date to Rows, Right-click Group, Years and Months
2. (02:04 minute mark) Group By Date: PowerPivot PivotTable:
3. (02:07 minute mark) Add Revenue Table to PowerPivot Data Model
4. (02:46 minute mark) Create Date/Calendar Table
5. (04:35 minute mark) Add Date/Calendar to PowerPivot Data Model
6. (05:05 minute mark) Add Calculated Column for Month Number using DAX MONTH function
7. (05:37 minute mark) Add Calculated Column for Month Name using DAX FORMAT function
8. (06:24 minute mark) Add Calculated Column for Year using DAX YEAR function
9. (06:58 minute mark) Sort Month Name by Month Number Column (to get months to show up in correct order)
10. (07:41 minute mark) Create Relationship between fRevenue Table and DCalendar Table.
11. (08:55 minute mark) Format Calculated Column so that Number Formatting shows up in PivotTable
12. (09:31 minute mark) Hide From Client Tool (Hide unwanted Fields in PivotTable Field List)
Where is Grouping Feature in Power Pivot?
Is there Group by Date in PowerPivot?
See how to:
1. (00:47 minute mark) Group By Date: Excel PivotTable: 1) Drag Date to Rows, Right-click Group, Years and Months
2. (02:04 minute mark) Group By Date: PowerPivot PivotTable:
3. (02:07 minute mark) Add Revenue Table to PowerPivot Data Model
4. (02:46 minute mark) Create Date/Calendar Table
5. (04:35 minute mark) Add Date/Calendar to PowerPivot Data Model
6. (05:05 minute mark) Add Calculated Column for Month Number using DAX MONTH function
7. (05:37 minute mark) Add Calculated Column for Month Name using DAX FORMAT function
8. (06:24 minute mark) Add Calculated Column for Year using DAX YEAR function
9. (06:58 minute mark) Sort Month Name by Month Number Column (to get months to show up in correct order)
10. (07:41 minute mark) Create Relationship between fRevenue Table and DCalendar Table.
11. (08:55 minute mark) Format Calculated Column so that Number Formatting shows up in PivotTable
12. (09:31 minute mark) Hide From Client Tool (Hide unwanted Fields in PivotTable Field List)
Where is Grouping Feature in Power Pivot?
Is there Group by Date in PowerPivot?
10 سال پیش
در تاریخ 1393/08/23 منتشر شده
است.
58,117
بـار بازدید شده