| 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.
|
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)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
