Forum Discussion
Power pivot
I created a data model in Power Pivot with two tables, the calendar table with data only on dates and variations in time measurements to meet the period referring to the data table and the data table...
So basically what is missing for the relationship between the calendar table and the data table to be effective would be to aggregate the dates in the data table into years, months, quarters and so on and then relate them in the power pivot? Rudy1956
Nope, it's enough to build relationships based only on Date field. If in data table are actual dates, not datetime formatted as date.
The question is what such relationship for and how to use it. PivotTable ignores any relationships if no aggregation is added to values. My guess was that's why you have such result.
Perhaps other reasons, but without sample file or more details it's hard to say.