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...
If your fields are dates it for the relationship it doesn't matter how fields are formatted. It shall be correct one-to-many and it's better to hide the field on many side.
In PivotTable if you have no aggregation it returns all fields from Raw part with full join, i.e. all values of the field again each value of another field. As soon as you add aggregation it shall work correctly.
- Sergei, thank you.
