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...
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.
Sergei, today I generated an aggregation of load weights in power pivot for data analysis using power pivot's pivot table feature. In the lines field, insert the information about the load identification number and in the values field the aggregation that adds up the weights of the loads. It worked, the relationship is correct. Thank you very much for your help and attention.
Rudy1956 , you are welcome