| Hide the Date column whenever you define a Dates table in PowerPivot |
| Written by Marco Russo |
| Tuesday, 29 June 2010 21:26 |
|
There are already several posts in the blogosphere about the need of using a separate Dates table in PowerPivot to make almost any type of analysis. An important step you should make whenever you have a Dates table (almost always, in theory!) is to hide the Date column of the table containing measures in the Pivot Table.
|
Author articles
- Using SSAS 2005/2008 as PowerPivot Data Source: Measures Are Imported as Text Columns
- Using SSAS 2005/2008 as PowerPivot Data Source: Direct MDX
- Using SSAS 2005/2008 as PowerPivot Data Source: Calculated Members
- Using SSAS 2005/2008 as PowerPivot Data Source: Query Designer
- Using SSAS 2005/2008 as PowerPivot Data Source: Calculated Members
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
- Recorded webcast - A Preview to PowerPivot Server Best Practices
